View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Excel Graph Problem - Need Help

I suspect you've used the stacked line chart (middle option in the chart
wizard) rather than the regular line chart (left option).

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


"smayers" wrote in message
...
After selecting the data to be displayed in the graph and creating the
line
graph, the data labels show the correct numbers, but they don't correspond
with the scale on the Y axis. Example: The amount is 42,000, but it is
plotted on the graph at about 52,000 and when you run the curser over it,
the
amount still says the correct #. There are multiple lines in the chart and
the first line is correctly plotted, but the rest are all off. If I plot
each
line on a separate chart then they turn out fine. How can I fix this?