Error with chart

M

millwalll

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

Andy Pope

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,Sheet1!$B$6),(Sheet1!$C$3,Sheet1!$C$4,Sheet1!$C$5,Sheet1!$C$6),1)

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


Cheers
Andy
 
M

millwalll

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Error Bars to Series and Colour 1
Filtered view of Visio Chart 0
Chart SERIES OFFSET 5
Odd Chart Format Results 1
Ways to create a budget chart for money managment 1
Gantt chart duration not showing 0
Move Chart with Text 0
Cannot see and gantt charts or other displays 0

Top