HOW CAN I ENTER LONG DATA ( 32 OR MORE )

  • Thread starter Thread starter EXCEL DATA VALUE TOO LONG
  • Start date Start date
E

EXCEL DATA VALUE TOO LONG

How can I enter more than 32 value in the source data when I create a XY line
chart
 
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]...
 
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
 
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.
 
Back
Top