Hi all,
I have a large spreadsheet, ~200 sheets. For each of these, I wish to
plot a series where the x values are D3:D103 and the y values are
E3:E103, and the series name is the same as that of the sheet, all on
the same chart.
So far I have
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(1).XValues = "='0,-1 '!R3C4:R103C4"
ActiveChart.SeriesCollection(1).Values = "='0,-1 '!R3C5:R103C5"
ActiveChart.SeriesCollection(1).Name = "=""0,-1 """
However, I am not sure how to loop this action to cover all worksheets
in the book, and not sure how to get excel to automatically write the
sheet name as the series name. Any ideas?
Thanks in advance.
-K
--
----------------------------------------------------------------------------------
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
