Can't reference Correctly

[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]

NO way to get help

 

[Jon Peltier]

You win. This was posted after several answers.

- Jon

 

[Don Guillett]

Jon, I even sent her a copy/paste of responses and got NO response. Guess
she only likes to ask.??

 

[Jon Peltier]

Yeah, but her return address is

(e-mail address removed)

She never got your message.

- Jon

 

[Don Guillett]

Sometimes it just doesn't pay to do all this free work.