problem with an Excel chart

[Miner Jeff]

I'm trying to create a basic line chart in Excel. There are 6 series
and each series has 5,000 data points.

The resulting curves are short, i.e., they don't expand when I resize
the chart. I also get a warning about the series size limit being
32,000 points. I have a total of 30,000 points among all 6 series.

In the Y-values box in the chart wizard, for example, I'm defining the
series in column B of tab A as A!$B2:$B5001, with the series name in
cell B1.

The scale for the x-axis only has options for number of categories
between tick marks and number of categories between tick marks. There
is no option to define max and min values.

I have a gut feeling that all the data is there. The min and max x-
value labels are shown in the chart, it's just that the curves are so
compressed (or skewed) towards the left side of the chart that the
curves are useless for making detailed observations of the data.

Any ideas are appreciated.

Thanks,

Miner Jeff

 

[Miner Jeff]

I'm trying to create a basic line chart in Excel. There are 6 series
and each series has 5,000 data points.

The resulting curves are short, i.e., they don't expand when I resize
the chart. I also get a warning about the series size limit being
32,000 points. I have a total of 30,000 points among all 6 series.

In the Y-values box in the chart wizard, for example, I'm defining the
series in column B of tab A as A!$B2:$B5001, with the series name in
cell B1.

The scale for the x-axis only has options for number of categories
between tick marks and number of categories between tick marks. There
is no option to define max and min values.

I have a gut feeling that all the data is there. The min and max x-
value labels are shown in the chart, it's just that the curves are so
compressed (or skewed) towards the left side of the chart that the
curves are useless for making detailed observations of the data.

Any ideas are appreciated.

Thanks,

Miner Jeff

Never mind. I had defined one of the series as the entire column, so
there were ~65,000 data points. It's working okay now.

Miner Jeff