Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Error with chart
I am trying to produce achat and i get
series format is too long what does this mean ?? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
How to add error bars to 3-D chart | Excel Discussion (Misc queries) | |||
Error in chart with 2 different series... | Charts and Charting in Excel | |||
Log chart error | Charts and Charting in Excel | |||
Error; chart wasn't found | Excel Discussion (Misc queries) |