Multiple charts Macro
Posted by Tamara on June 01, 2000 2:57 AM
I have had problems creating a Macro that produces series of charts.
I have on each sheet 2 sections of data in which each section consists of 2 columns A:B (10 Rows in depth)
(The 1st section of data = A5:B14. The 2nd section of data = A16:B25).
The amount of sheets in the WorkBook can vary.
I need a Macro that will create 2 "Area" graphs from the data specified on each WorkBook until there is no more data available.
Also added in the 1st chart a Title "Revenue" in the Y axis and in the 2nd chart "Minutes" again in the Y axis. (Deleted = the Chart Title on both and the legend on top)
Can this be done? The other problem is that I need to then reduce the size of the chart and its final position.
Is this impossible? Is this clear enough?
Thanks to anyone who can help.