I'd like to create a chart, many times over.
My data is in XY format.
Upon using the recording feature, it locks in a specific chart name,
"Chart1"; and also, locks in a specific data range, "A1:F5".
I was wanting to create this XY chart with A1:F5 for Chart1, then have
it move down and grab A7:F11 for Chart2, and so on. I have about 100
or so data ranges to create that many charts.
How can I make these references relative or unlock the specific cell
address?
Any help would be greatly appreciated.
Thanks!,
Kevin
--
quickcreator
Bookmarks