The best thing to do is to rearrange your data. Five minutes with your
data will save five hours of aggravation later.

If you can't rearrange the existing data, set up another sheet or part
of a sheet that has contiguous ranges. Link back to the discontiguous
ranges in the original data. Use this new range for the chart's source data.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Morten wrote:
Hi,

I have a weekly weekly data set that is the basis for a trend graph for one
year. This works ok until about the 16th week, then I get "Series formula is
too long".

It seems the use of named range is the only way around this...?

I have tried this, looked through previous posts and replies here, but this
does not work for me. It seems only applicable to very simple data sets and
graphs.

The data set is as follows:

There are two rows of headers (X) - the first is the week's number, the row
below has the value of the week - for instance "Incoming". Each week contains
4 columns, so there is no continous range over the weeks for "Incoming".

The Y contains the company names.

I don't know how the formatting will be for this post, but I'll try and make
a simple table-example of this:

W49 W49
W50
Incoming Outgoing
Incoming
Company1 200 185 105
Company2 3500 3320 2705


Regards
Morten