add source data to chart in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan - 24 Apr 2008 18:06 GMT

I can't get Excel to accept more than 19 data points for my X-axis in a
chart? Is this a limit? How do I add more data points? (As soon as I try to
add the 20th point, all of the other points are lost.)

Reply to this Message

Sandy - 24 Apr 2008 19:15 GMT

Hi Susan

I have had this trouble in the past. Try....

Right click chart and select 'Source Data'.
Delete any existing source data and close dialog box.
Select the source data you require and copy it.
Click on the chart and paste.

Sandy

> I can't get Excel to accept more than 19 data points for my X-axis in a
> chart? Is this a limit? How do I add more data points? (As soon as I try
> to
> add the 20th point, all of the other points are lost.)

Reply to this Message

Susan - 24 Apr 2008 19:36 GMT

Wow. It works! That's what I like about Excel. There's always a way to get
around a problem! Thank you so much!

> Hi Susan
>
[quoted text clipped - 11 lines]
> > to
> > add the 20th point, all of the other points are lost.)

Reply to this Message

Jon Peltier - 24 Apr 2008 22:22 GMT

The best way around this problem is to put your data into a contiguous
range, so you don't have to select a bunch of individual cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

> Wow. It works! That's what I like about Excel. There's always a way to get
> around a problem! Thank you so much!
[quoted text clipped - 15 lines]
>> > to
>> > add the 20th point, all of the other points are lost.)

Reply to this Message