Manipulating Charts

[frizzy]

Let's say I have a workbook with 6 sheets. One sheet has raw data, the other five are different types of charts based on that data. Along the top of my data page, I have every month for 2001, and 2002. So Jan to Dec, and then starting over at Jan and ending at Dec 2002. Down the side, I have different types of revenue. And the charts show this info. So there is one line in my line chart for 2001, 2002 and so on. Now what I want to do is add info to my data page for Jan through June, 2003 (so that I have a new line)and I want to show it in my charts. I think what I have to do is right click on the chart, go to source data and add a new series? Am I right? Is there a way to easily add this new information without having to do it for each chart?

(Hopefully this is clear................) :D

 

[nevillestoke]

I'm not exactly sure what you're asking - but it sounds like your answer may be to group the sheets (right click on the "tab" and "select all sheets" or Shift Click to select certain sheets) If your data is in the same position on each sheet, adding new data on one of the selected sheets will add it onto all selected sheets. To ungroup the sheets, either click on a non-selected sheet or right click on the "tab" and select "ungroup".

If this is not what you are looking for perhaps you can respond with more specifics.