Thread: Data showing incorrectly on line chart

I'm having difficulty with a line chart. I've got two ranges of numbers of
two types of calls (from 1972 through 2004) that goes up from 50 to 7700. My
chart's Y axis has automatically decided to show from 0 to 16,000. On the
chart itself, my data starts being placed at about 6,000 (for both 24 "F"
calls and 649 "M" calls in the year 1972) and goes up to a point above 14,000
(for a figure that should only be just above 7000). When I hover over the
points, it give me the right number, yet it shows it in the wrong place.

I've tried to change the scale of my Y axis, but when I am able to so (2 out
of 5 times) my data then goes off the chart. So I've looked at my data to
see if it's fouled up. But it shows exactly like I want it on the
spreadsheed and there are no formulas in the cells.

Any clues? I'm using Excel 2002.

Hi,

Are you using a stacked line chart by any chance?

Cheers
Andy

gobonniego wrote:
> I'm having difficulty with a line chart. I've got two ranges of numbers of
> two types of calls (from 1972 through 2004) that goes up from 50 to 7700. My
> chart's Y axis has automatically decided to show from 0 to 16,000. On the
> chart itself, my data starts being placed at about 6,000 (for both 24 "F"
> calls and 649 "M" calls in the year 1972) and goes up to a point above 14,000
> (for a figure that should only be just above 7000). When I hover over the
> points, it give me the right number, yet it shows it in the wrong place.
>
> I've tried to change the scale of my Y axis, but when I am able to so (2 out
> of 5 times) my data then goes off the chart. So I've looked at my data to
> see if it's fouled up. But it shows exactly like I want it on the
> spreadsheed and there are no formulas in the cells.
>
> Any clues? I'm using Excel 2002.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info