Remember Me?

#1
December 9th 05, 04:12 PM posted to microsoft.public.excel.charting
 jantoni Posts: n/a
Is there a limit to the number of points in a chart source data

I'm trying to put in a value range in a chart. The cells are every other
cell. When I start selecting the cells I can only click on 10 cells. On
number 11 I get a bell sound and the value source data block goes back to
displaying only a =.

Any Ideas would be greatly appreciated.

Thx

#2
December 9th 05, 04:43 PM posted to microsoft.public.excel.charting
 Andy Pope Posts: n/a
Is there a limit to the number of points in a chart source data

Hi,

There is a limit to the number of data points, 32k, but that is not the
limit you are hitting. The series formula has a limit.
The series formula looks something like this. This is for a chart based
on data in B2:B5 with axis labels in A2:A5 and series name in B1.

=SERIES(Sheet1!\$B\$1,Sheet1!\$A\$2:\$A\$5,Sheet1!\$B\$2:\$ B\$5,1)

this is the same chart but with on two non-adjacent cells.
=SERIES(Sheet1!\$B\$1,(Sheet1!\$A\$2,Sheet1!\$A\$4),(She et1!\$B\$2,Sheet1!\$B\$4),1)

Notice the formula is longer but with fewer data points. The length of
the formula is approx 1000 characters. So you can how quickly you are
going to exceed the limit with only a few points.

The way around this is to build a contiguous array of chart data.

Jon Peltier has some more detailed explanation on charts and the data
sources.
http://peltiertech.com/Excel/ChartsH...esFormula.html
http://peltiertech.com/Excel/ChartsH...iffSheets.html

Cheers
Andy

jantoni wrote:
I'm trying to put in a value range in a chart. The cells are every other
cell. When I start selecting the cells I can only click on 10 cells. On
number 11 I get a bell sound and the value source data block goes back to
displaying only a =.

Any Ideas would be greatly appreciated.

Thx

--

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM Marc Charts and Charting in Excel 3 November 19th 05 06:31 PM James Charts and Charting in Excel 6 August 16th 05 05:07 PM Suzuki7 Charts and Charting in Excel 2 February 15th 05 04:55 AM Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM

All times are GMT +1. The time now is 05:45 AM.