Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
gobonniego
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Data showing incorrectly on line chart

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line Chart Aurora Charts and Charting in Excel 1 March 8th 06 10:27 PM
how can I limit my chart Richard Erlacher Charts and Charting in Excel 7 March 7th 06 01:08 PM
Displaying data in bar form on a line chart expo Charts and Charting in Excel 1 March 2nd 06 12:10 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"