Problem updating references on a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Katie, You do NOT win friends by continuing to post the same question over
and over.
 
Hey friends, let's give her a break. Her three posts are identical and time stamped
within three seconds of each other, and she posted using the CDO web interface. Even
though they've revamped the interface, I still don't really know what it's doing. I
know I've never pressed the send button two or three times</snort>, but it happens.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top