|  | Excel (2007) Chart Refuses to Accept More Data Points | | |
| | | Fletch |  |
|  Posted: Fri Aug 29, 2008 9:25 pm Post subject: Excel (2007) Chart Refuses to Accept More Data Points |  |
I have a simple chart set up that references data points which are
vertically ten spaces apart. The chart has worked fine for months.
However, when I went to update it with another series point today it
simply will not "OK" the extra point. I click enter, I click okay,
and NOTHING. It's not just one chart that this is happening with,
either. In the same file I have another chart that references another
point that is spaced like the previous one but I have the same
problem. I've never had this happen before and tooling around with it
hasn't yielded any fruit.
Some sagacious wisdom would be MUCH appreciated.
Thanks. |
| |
| | | Andy Pope | |
| | Posted: Sat Aug 30, 2008 8:12 am Post subject: Re: Excel (2007) Chart Refuses to Accept More Data Points | |
| |  | |
Hi,
The series formula has a limit of ~1024 characters. When using non
contiguous cells as data source it is easy to exceed this limit.
The following demonstrates how the length of the series formula can
rapid expand.
10 contiguous cells,
=SERIES(,,Sheet1!$A$1:$A$10,1)
10 non-contiguous cells,
=SERIES(,,(Sheet1!$A$1,Sheet1!$A$3,Sheet1!$A$5,Sheet1!$A$7,Sheet1!$A$9,Sheet1!$A$11,Sheet1!$A$13,Sheet1!$A$15,Sheet1!$A$17,Sheet1!$A$19),1)
You need to create a contiguous block, using formula, for the data to be
charted.
Cheers
Andy
Fletch wrote:
| Quote: | I have a simple chart set up that references data points which are
vertically ten spaces apart. The chart has worked fine for months.
However, when I went to update it with another series point today it
simply will not "OK" the extra point. I click enter, I click okay,
and NOTHING. It's not just one chart that this is happening with,
either. In the same file I have another chart that references another
point that is spaced like the previous one but I have the same
problem. I've never had this happen before and tooling around with it
hasn't yielded any fruit.
Some sagacious wisdom would be MUCH appreciated.
Thanks.
|
--
Andy Pope, Microsoft MVP - Excel
LINK |
| |
|
|
