ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Large Plot (limits exceeded) (https://www.excelbanter.com/charts-charting-excel/107285-large-plot-limits-exceeded.html)

Gregor

Large Plot (limits exceeded)
 
I have collected two data points for 18 months, 24/7. Puts that at 157K.
That is Station 1 & Station 2, date, time, reading1, reading 2.
When I went to chart in Excel got the message that the width was limited to
255 in the chart.

Any suggestion on how to display the data?

XP, XL 2003.

Thanks,

Gregor



HEK

Large Plot (limits exceeded)
 
Gregor, check the helpfile on Excel specifications and limits (charting).
You'll notice Excel has a limit of 255 data series, 256,000 data points
(32,000 per series). Cld it be you have defined each data point as a
separate series?
HTH,
Henk

"Gregor" wrote:

I have collected two data points for 18 months, 24/7. Puts that at 157K.
That is Station 1 & Station 2, date, time, reading1, reading 2.
When I went to chart in Excel got the message that the width was limited to
255 in the chart.

Any suggestion on how to display the data?

XP, XL 2003.

Thanks,

Gregor




Gregor

Large Plot (limits exceeded)
 
That must have been it. Thanks very much for the help. Now trying to make
it look "pretty!"

G.


"HEK" wrote in message
...
Gregor, check the helpfile on Excel specifications and limits (charting).
You'll notice Excel has a limit of 255 data series, 256,000 data points
(32,000 per series). Cld it be you have defined each data point as a
separate series?
HTH,
Henk

"Gregor" wrote:

I have collected two data points for 18 months, 24/7. Puts that at
157K.

That is Station 1 & Station 2, date, time, reading1, reading 2.
When I went to chart in Excel got the message that the width was limited
to
255 in the chart.

Any suggestion on how to display the data?

XP, XL 2003.

Thanks,

Gregor







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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com