HOW CAN I ENTER LONG DATA ( 32 OR MORE )

[EXCEL DATA VALUE TOO LONG]

How can I enter more than 32 value in the source data when I create a XY line
chart

 

[David Biddulph]

From Excel specification limits:
"Data series in one chart 255
Data points in a data series for 2-D charts 32,000
Data points in a data series for 3-D charts 4,000
Data points for all data series in one chart 256,000"

Where does your limit of 32 come in?
--
David Biddulph

"EXCEL DATA VALUE TOO LONG" <EXCEL DATA VALUE TOO
(e-mail address removed)> wrote in message
news:[email protected]...

 

[EXCEL DATA VALUE TOO LONG]

When I hold down the Ctrl Key and click on cells for data, but the Source
Data -values : blank out after cell no 30th
and return with data error, fomula too long

 

[David Biddulph]

Are you trying to use non-contiguous cells from your worksheet as your data
range?
The best bet is to include a new range in your worksheet. From consecutive
cells in the new range you can link in turn to each of your non-contiguous
points, then the chart can be plotted from your new range.