View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Libby Libby is offline
external usenet poster
 
Posts: 151
Default Changing many charts in one worksheet

I have a worksheet with over 100 similar small datatables and charts. It has
been asked of me that I now chart one more column of data from each table.
The data is there and I can record a simple macro to plot the additional
series from the first table to the first chart. My question is, how do I get
the macro to go to the next table and plot the additional data to the next
chart. The data is always in the same column, different rows.