add source data to chart in excel

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

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.)
 
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
 
Wow. It works! That's what I like about Excel. There's always a way to get
around a problem! Thank you so much!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
Line & Column on Two Axes for Blood Pressure & Weight 3
Plot value at top of chart 1
How to embed expression in data labels on a chart 2
Overlaying 2 Data Series with Different Time (X) Axis 3
X Y (Scatter) Chart EXCEL 2007 1
Pivot Chart - X-axis labels when adding data 0
using Access Data 1

Back
Top