Incorrect date in line chart in Excel.

G

gobonniego

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 placement starts 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). 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 spreadsheet.

Any clues? I'm using Excel 2002.

Bonnie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top