Can't update chart

[Katie]

Hello,

I have a spreadsheet with 50 tabs. Each tab has a 6 month audit score that
looks like this:

MAR APR MAY JUN JUL AUG
100% 100% 100% 100% 100% 100%

There is a bar graph linked to these cells on each tab. What I am trying to
do is group the tabs together, then delete the MAR score, shift all cells to
the left, then add a SEP score.

The problem is... when I try to do that, the graph changes to only show APR
MAY JUN JUL & AUG. I can't get it to automatically add SEP.

I could do it individually but that would be very time consuming to do it
for 50 tabs each month.

Is there an easier way??? Any help is appreciated. Thanks...

Katie

 

[Don Guillett]

Dave has a chart by month example where you need not delete anything.

www.ozgrid.com

 

[Tushar Mehta]

You could set up the charts to dynamically adjust to show the last 6
months of data as in
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

With the above technique there would be no need to delete the Mar data.

Alternatively, if you must delete the Mar data, check out the use of
the INDIRECT function.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions