inaccurate line chart

[Tom H.]

Hi...I'm fairly new to charting. I'm creating a line chart with years along
the category axis and dollars as values. Seems pretty simple. The data
consists of 3 items: sales, expenses, and net income. When I include these 3
together and create a chart, the scale doubles and expenses and net income
are shown as greater than sales. When you click the data points, though,
they are accurate. For instance, the data point might be 5,000, but it's
shown at the 10,000 level on the chart.

In a nutshell:
Sales appears right where it should be on the scale
Expenses appears about double what it should be (although data point is
accurate)
Net Income appears about double (data point accurate)

I don't get this behavior when I chart these items separately, or when I use
something like a column chart.

What in the world is wrong?

Thanks.

 

[Jon Peltier]

Sounds like you've made a stacked line chart, where each series is plotted
atop the previous one. These are in the second column of line chart types in
the wizard. Choose instead from the first column of options (but not the
hideous 3D line/ribbon chart).

- Jon

 

[Tom H.]

That's exactly it. Thanks.

Sounds like you've made a stacked line chart, where each series is plotted
atop the previous one. These are in the second column of line chart types
in the wizard. Choose instead from the first column of options (but not
the hideous 3D line/ribbon chart).

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

 

[Pete Grandstaff]

Jon, Tom, Thanks, another 'soul' helped. Pete



Jon Peltier wrote:

Sounds like you've made a stacked line chart, where each series is plotted
18-Sep-07

Sounds like you've made a stacked line chart, where each series is plotted
atop the previous one. These are in the second column of line chart types in
the wizard. Choose instead from the first column of options (but not the
hideous 3D line/ribbon chart)

- Jo
------
Jon Peltier, Microsoft Excel MV
Tutorials and Custom Solution
Peltier Technical Services, Inc. - http://PeltierTech.co
______


Previous Posts In This Thread:

inaccurate line chart
Hi...I'm fairly new to charting. I'm creating a line chart with years along
the category axis and dollars as values. Seems pretty simple. The data
consists of 3 items: sales, expenses, and net income. When I include these 3
together and create a chart, the scale doubles and expenses and net income
are shown as greater than sales. When you click the data points, though,
they are accurate. For instance, the data point might be 5,000, but it's
shown at the 10,000 level on the chart

In a nutshell
Sales appears right where it should be on the scal
Expenses appears about double what it should be (although data point is
accurate
Net Income appears about double (data point accurate

I don't get this behavior when I chart these items separately, or when I use
something like a column chart

What in the world is wrong

Thanks.

Sounds like you've made a stacked line chart, where each series is plotted
Sounds like you've made a stacked line chart, where each series is plotted
atop the previous one. These are in the second column of line chart types in
the wizard. Choose instead from the first column of options (but not the
hideous 3D line/ribbon chart)

- Jo
------
Jon Peltier, Microsoft Excel MV
Tutorials and Custom Solution
Peltier Technical Services, Inc. - http://PeltierTech.co
______


Re: inaccurate line chart
That's exactly it. Thanks.


Submitted via EggHeadCafe - Software Developer Portal of Choice
510 Color Palette Selection Complete Code Snippet
http://www.eggheadcafe.com/tutorial...5-f9e649563caf/510-color-palette-selecti.aspx