Problem when trying to change source data

  • Thread starter Thread starter Beverly Darvill
  • Start date Start date
B

Beverly Darvill

I have a lot of charts that holds data from 3 years at the current moment in
time. At the moment the chart displays the data from Oct 08 to Dec 09 and I
want to change that to display Jan 09 to Dec 10 and I have been modifying the
source data to the formula below

='Resource Groups'!$A$2:$A$70,'Resource Groups'!$N$2:$AK$70

- however through a trial and error I find that when I extend the data on
the vertical axis in the legend it displays the words Series 1 through to
Series 70 and since I have approximately 100 charts to amend I do not have
the time to go through each one and add the legend individually.

The odd thing is that on some charts amending the source data works fine and
the legend displays what it is meant to.

Can anyone suggest why this is now happening. I am running Excel 2003.

thanks
Beverly
 
Modify your data so that series names are in the first row (or column),
the dates are in the first column (or row), the values are in the rest
of the range, and the top left cell is completely blank. This might mean
putting your series names in N1:AK1, then using A1:A70,N1:AK70 as your
chart source data.

- Jon
 
Jon

The first range ($a$1:$a$70) (this lists the resource group name) is the
series names and the second ($N$1:$ak$70) (the figures against each resource
name) are the values - in the same spreadsheet I have another chart that
takes the data from below

='FTE by Resource Type'!$A$1:$A$70,'FTE by Resource Type'!$N$1:$AK$70,'FTE
by Resource Type'!$A$74,'FTE by Resource Type'!$N$74:$AK$74

and I modify it in exactly the same way and it works perfectly.

Beverly
 
Where are your X values (category labels)?

Are both charts the same type? Excel makes different assumptions for XY
charts than for other types.

- Jon
 
Jon

Sorry for the delay

It will let me change the values of the X axis currently is
='Resource Groups'!$K$1:$Y$1 and it is quite happy for me to change it to
='Resource Groups'!$N$1:$AK$1

Currently the Y axis is covered in the statement
='Resource Groups'!$A$1:$A$59

and if I try to change it to
='Resource Groups'!$A$1:$A$70 then I get the word series1 to series 69 in
the ledgend.

The problem occurs when I try to extend downwards
 
Back
Top