Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2008

Tip: Looking for answers? Try searching our database.

Excel (2007) Chart Refuses to Accept More Data Points

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Fletch - 29 Aug 2008 22:25 GMT
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 - 30 Aug 2008 11:12 GMT
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

> I have a simple chart set up that references data points which are
> vertically ten spaces apart.  The chart has worked fine for months.
[quoted text clipped - 9 lines]
>
> Thanks.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.