Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
why won't excel allow me to add more data to a chart?
For some of my data I skip days for collecting it so I use the shift key to
click on the days I do want in the chart. I have been doing this for awhile but now that I'm obtaining more points it has simply stopped letting me add data points. When I click on the one where it stops collecting it erases all of the others I have clicked and makes a stop noise. I need to add more data so why won't it let me?? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
why won't excel allow me to add more data to a chart?
Hi,
There is a finite limit on the length of the series formula, ~1024 characters. So this example is for a series with 3 data points in cells A2:B4. =SERIES(,Sheet1!$A$2:$A$4,Sheet1!$B$2:$B$4,1) If I use the SHIFT key and select each row individually the formula grows to =SERIES(,(Sheet1!$A$2,Sheet1!$A$3,Sheet1!$A$4),(Sh eet1!$B$2,Sheet1!$B$3,Sheet1!$B$4),1) The simplest way around this is to create a contiguous range of chart data. Cheers Andy On 25/05/2010 20:27, chrluce wrote: For some of my data I skip days for collecting it so I use the shift key to click on the days I do want in the chart. I have been doing this for awhile but now that I'm obtaining more points it has simply stopped letting me add data points. When I click on the one where it stops collecting it erases all of the others I have clicked and makes a stop noise. I need to add more data so why won't it let me?? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
Excel Chart and Data to PPT | Charts and Charting in Excel | |||
Excel chart source data y-values can only accept 7 data pts? | Charts and Charting in Excel | |||
excel chart data-labels | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |