View Single Post
  #1   Report Post  
quickcreator
 
Posts: n/a
Default Create Multiple Charts w/ VB


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