Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Graph Problem - Need Help
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Graph Problem - Need Help
You were right! Thank you so much. I knew it was some minor detail that was
my own fault. It was driving me crazy though! I spent a good hour trying to figure out how to adjust the scales to make it work! Shellie "Jon Peltier" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem Printing Excel Graph -data doesn't show up when printed | Charts and Charting in Excel | |||
Excel 2003, graph y axis labelling problem | Charts and Charting in Excel | |||
Excel graph problem | Excel Discussion (Misc queries) | |||
Graph Problem | Excel Discussion (Misc queries) | |||
Help with an excel graph problem | Charts and Charting in Excel |