View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
PatrickJ PatrickJ is offline
external usenet poster
 
Posts: 7
Default Replicating a Chart with new data

I have formatted a chart using a specific data set referring to one
enterprise. I want to duplicate / replicate that same chart for a second and
third etc enterprise from different data on the same worksheet. I want to
have a series of separate cgarts within the workbook all dynamically linked
to the data sheet. I hope this is clear - I amtrying to save time by not
having to reformat every new chart as there are 47 of them!