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:excel-macros@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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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
