Error with chart
 

I am trying to produce achat and i get
series format is too long what does this mean ?? Thanks

Error with chart
 

Hi,

A each series in the chart has a formula, appears in the formula bar
when the series is selected, for example,

=SERIES(,Sheet1!$B$3:$B$6,Sheet1!$C$3:$C$6,1)

This formula is restricted to a length of 1024 characters.

Formula normally gets to long if the cell are non-contiguous, for
example using same data range but selected whilst holding CTRL ,

=SERIES(,(Sheet1!$B$3,Sheet1!$B$4,Sheet1!$B$5,Shee t1!$B$6),(Sheet1!$C$3,Sheet1!$C$4,Sheet1!$C$5,Shee t1!$C$6),1)

If this is the problem try placing the data in a contiguous block.


Cheers
Andy

millwalll wrote:
I am trying to produce achat and i get
series format is too long what does this mean ?? Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Error with chart
 

Thanks for that I gussed it was somthing to do with that but just want to be
100% sure

"Andy Pope" wrote:

Hi,

A each series in the chart has a formula, appears in the formula bar
when the series is selected, for example,

=SERIES(,Sheet1!$B$3:$B$6,Sheet1!$C$3:$C$6,1)

This formula is restricted to a length of 1024 characters.

Formula normally gets to long if the cell are non-contiguous, for
example using same data range but selected whilst holding CTRL ,

=SERIES(,(Sheet1!$B$3,Sheet1!$B$4,Sheet1!$B$5,Shee t1!$B$6),(Sheet1!$C$3,Sheet1!$C$4,Sheet1!$C$5,Shee t1!$C$6),1)

If this is the problem try placing the data in a contiguous block.


Cheers
Andy

millwalll wrote:
I am trying to produce achat and i get
series format is too long what does this mean ?? Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info