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

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" wrote:

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

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.
--
David Biddulph

"EXCEL DATA VALUE TOO LONG"
wrote in message
...
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" wrote:

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