| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
add source data to chart in excel
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.) |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
add source data to chart in excel
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 "Susan" wrote in message ... 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.) |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
add source data to chart in excel
Wow. It works! That's what I like about Excel. There's always a way to get
around a problem! Thank you so much! "Sandy" wrote: 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 "Susan" wrote in message ... 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.) |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
add source data to chart in excel
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 _______ "Susan" wrote in message ... Wow. It works! That's what I like about Excel. There's always a way to get around a problem! Thank you so much! "Sandy" wrote: 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 "Susan" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel changes chart source data. Drops the Filename reference from | Excel Discussion (Misc queries) | |||
| Excel chart source data y-values can only accept 7 data pts? | Charts and Charting in Excel | |||
| excel chart with data source from an access query | Charts and Charting in Excel | |||
| Excel 2007 - How do I quickly update a chart using Source data? | Charts and Charting in Excel | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Linear Mode
