Thanks! :) On Wed, Jun 22, 2011 at 9:18 PM, ashish koul <koul.ash...@gmail.com> wrote:
> 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 > -- ---------------------------------------------------------------------------------- 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