Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 9th 05, 03:12 PM posted to microsoft.public.excel.charting
jantoni
 
Posts: n/a
Default 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   Report Post  
Old December 9th 05, 03:43 PM posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Why doesn't my chart update when underlying data changes? Marc Charts and Charting in Excel 3 November 19th 05 05:31 PM
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
How do I automatically update chart source data links for moved fi Suzuki7 Charts and Charting in Excel 2 February 15th 05 03:55 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017