Re: Too Much Chart Data for Excel Col Limits

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well, yeah, but transposing would definitely get us into trouble with the
OTHER dimension of their data, which is part numbers -- they virtually ALWAYS
have more than 256 part numbers. That's why my thoughts turned to
calculating and storing all the necessary values in a two-dimension array, if
an array can serve as a chart data source. I know vaguely that a range of
cells can be treated as an array for some purposes, so I was hoping the
reverse is also true: that an array can be treated as a range of cells
that's just too big to fit on a worksheet.

"Jon Peltier" wrote:

Another limit is 255 series per chart. Therefore, transposing the data will
provide sufficient space for 20 years * 52 weeks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"LarryP" <LarryP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:91C47AD3-5E41-431A-8039-A0B68C0B9D69@xxxxxxxxxxxxxxxx
Didn't know 1), thanks for pointing it out.

The line chart they're working with is about progress over time on a
project, with one data point for each week looking into the future. In
some
instances they are using a time horizon of several years, so they need 52
* x
columns. the 256 available columns let them go out more or less five
years,
but in some instances that's already proving to be insufficient. I would
think ten years/520 columns would do, but let's worst-case it at 20
years/1040 columns. (As far as rows is concerned, I haven't heard that
65535
is a problem for them, but they do sometimes use as much as 30,000 rows or
so.)

As to readability, I hear you, but that's their call. If I give them what
they want and it's ugly, that's on them.

"Bernard Liengme" wrote:

1) Have you recalled that there is a 32,000 limit on the size of a data
series?
2) Will the chart be readable even with 1,000 data points?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"LarryP" <LarryP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E8D53003-A673-4901-8B8C-A91FF5FA4DFB@xxxxxxxxxxxxxxxx
I have a user who wants to generate a chart from a really large set of
data,
too much to fit within the 256 columns available in Excel 2003. (No,
transposing the data won't work either, there's too much in BOTH
directions!)

Can anybody suggest a way to handle that? I thought about dumping all
the
values into an array variable, but don't know a way to make that the
data
source for a chart.






.

Relevant Pages

  • Re: Chart Seriew Values
    ... Jon Peltier, Microsoft Excel MVP ... When creating a chart from a memory array Excel tries to ...
    (microsoft.public.excel.programming)
  • Re: Too Much Chart Data for Excel Col Limits
    ... Another limit is 255 series per chart. ... Jon Peltier, Microsoft Excel MVP ... transposing the data won't work either, ...
    (microsoft.public.excel.charting)
  • Re: Too Much Chart Data for Excel Col Limits
    ... Either one or the other items has to stop at 256, since a chart cannot ... Jon Peltier, Microsoft Excel MVP ... an array can serve as a chart data source. ...
    (microsoft.public.excel.charting)
  • Re: Too Much Chart Data for Excel Col Limits
    ... Either one or the other items has to stop at 256, since a chart cannot ... Jon Peltier, Microsoft Excel MVP ... an array can serve as a chart data source. ...
    (microsoft.public.excel.charting)
  • Re: SUMPRODUCT wont work on a row
    ... I don't believe that it mentions transposing an array constant, ... mention transposing a range array using TRANSPOSE, which is the same effect, ... Microsoft Excel MVP ...
    (microsoft.public.excel.worksheet.functions)