try this http://peltiertech.com/Excel/Charts/
On Wed, Jun 22, 2011 at 7:56 PM, Chandra Shekar < chandrashekarb....@gmail.com> wrote: > Pleaase can I get 2007 code to get good looking chart as 2003. Thanks! > > On Wed, Jun 22, 2011 at 2:04 PM, ashish koul <koul.ash...@gmail.com>wrote: > >> Sub check() >> If Application.Version = "12.0" Then >> >> >> ' code for 2007 >> End If >> If Application.Version = "11.0" Then >> 'code for 2003 >> >> End If >> End Sub >> >> >> >> >> >> >> >> >> On Wed, Jun 22, 2011 at 11:15 AM, Chandra Shekar < >> chandrashekarb....@gmail.com> wrote: >> >>> Hi, >>> >>> Can we write different code do this. Where VBA code knows which version >>> user is using according to that it changes chart plot area. If yes please >>> let me know. Thanks! >>> >>> On Wed, Jun 22, 2011 at 12:34 AM, Daniel <dcolarde...@free.fr> wrote: >>> >>>> Charts are quite different with Excel2007, so you have to resize the >>>> plot area, change the series colors in order to get something similar. I >>>> use >>>> Excel 2010 which is still different from Excel 2007.**** >>>> >>>> ** ** >>>> >>>> Daniel**** >>>> >>>> ** ** >>>> >>>> *De :* excel-macros@googlegroups.com [mailto: >>>> excel-macros@googlegroups.com] *De la part de* Chandra Shekar >>>> *Envoyé :* mardi 21 juin 2011 07:49 >>>> >>>> *À :* excel-macros@googlegroups.com >>>> *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code**** >>>> >>>> ** ** >>>> >>>> Hi,**** >>>> >>>> **** >>>> >>>> Graph output is different compare to 2003 and 2007. I have pasted both >>>> the graphs in "Analysis Sheet". 2003 Ouput is that which is produced in >>>> 2003 >>>> which is perfect, but 2007 output which is pasted just below the data is >>>> generated in 2007 which is not as 2003 output. **** >>>> >>>> **** >>>> >>>> Please run this code in both 2003 and 2007 you can find the difference. >>>> **** >>>> >>>> **** >>>> >>>> Thanks,**** >>>> >>>> **** >>>> >>>> Chandra Shekar**** >>>> >>>> On Mon, Jun 20, 2011 at 11:46 PM, Daniel <dcolarde...@free.fr> wrote:** >>>> ** >>>> >>>> Hi,**** >>>> >>>> **** >>>> >>>> Can you ell which macro is involved and which result is different ?**** >>>> >>>> **** >>>> >>>> Regards.**** >>>> >>>> Daniel**** >>>> >>>> **** >>>> >>>> *De :* excel-macros@googlegroups.com [mailto: >>>> excel-macros@googlegroups.com] *De la part de* Chandra Shekar >>>> *Envoyé :* lundi 20 juin 2011 10:19 **** >>>> >>>> >>>> *À :* excel-macros@googlegroups.com**** >>>> >>>> *Objet :* Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code **** >>>> >>>> **** >>>> >>>> Hi,**** >>>> >>>> **** >>>> >>>> I am getting different output in 2003 & 2007 I gave pasted that in >>>> attached workbook. Please let me know if you have any queries regarding >>>> this. Thanks!**** >>>> >>>> **** >>>> >>>> Regards,**** >>>> >>>> **** >>>> >>>> Chandra Shekar B**** >>>> >>>> **** >>>> >>>> >>>> >>>> **** >>>> >>>> On Sat, Jun 18, 2011 at 12:05 AM, Daniel <dcolarde...@free.fr> wrote:** >>>> ** >>>> >>>> Hi,**** >>>> >>>> **** >>>> >>>> I don’t think there are tool to automate the processbecause the syntax >>>> is very similar. Can you post your code and tell which line produces the >>>> error ?**** >>>> >>>> **** >>>> >>>> Regards.**** >>>> >>>> Daniel**** >>>> >>>> **** >>>> >>>> *De :* excel-macros@googlegroups.com [mailto:e >>>> xcel-mac...@googlegroups.com] *De la part de* Chandra Shekar >>>> *Envoyé :* vendredi 17 juin 2011 10:13 >>>> *À :* excel-macros@googlegroups.com >>>> *Objet :* $$Excel-Macros$$ 2003 to 2007 : VBA Code**** >>>> >>>> **** >>>> >>>> Hi,**** >>>> >>>> **** >>>> >>>> How to convert 2003 VBA code to 2007, because some of codes what I am >>>> running in 2003 is not running in 2007. Is there any way to convert this to >>>> any office to get the same result.**** >>>> >>>> **** >>>> >>>> I am getting following error... Run-time error '-2147467259 >>>> (800004005'): >>>> The specified dimension is not valid for the current chart type. **** >>>> >>>> Thanks,**** >>>> >>>> **** >>>> >>>> Chandra Shekar B**** >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel**** >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel**** >>>> >>>> **** >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel**** >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel**** >>>> >>>> ** ** >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel**** >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> *Regards* >> * * >> *Ashish Koul* >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >> http://akoul.posterous.com/ >> *akoul*.wordpress.com <http://akoul.wordpress.com/> >> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> >> >> >> P Before printing, think about the environment. >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> http://akoul.posterous.com/ *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel