Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Source Data Inaccurate on Chart
I am using Xcel 2002. I have created a Annual Sales spreadsheet. I am
attempting to chart 2 lines (Sales and Expenses). When I insert a chart on another worksheet (same file) I cannot get the lines on the chart to agree with the spreadsheet. I can get one of the lines to show correctly but as soon as I add the other line (doesn't matter which one) the second line charts at almost double the amount. I think the Y axis is not agreeing but can't figure out why. Appreciate any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Source Data Inaccurate on Chart
As I answered in the other newsgroup:
You've created a stacked line chart, in which the second series shows the sum of the first two sets of data. A third series would be added on top of that, etc. You need to create a regular line chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bo" wrote in message ... I am using Xcel 2002. I have created a Annual Sales spreadsheet. I am attempting to chart 2 lines (Sales and Expenses). When I insert a chart on another worksheet (same file) I cannot get the lines on the chart to agree with the spreadsheet. I can get one of the lines to show correctly but as soon as I add the other line (doesn't matter which one) the second line charts at almost double the amount. I think the Y axis is not agreeing but can't figure out why. Appreciate any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inaccurate line chart | Charts and Charting in Excel | |||
pie chart & column chart w/same source data | Charts and Charting in Excel | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
LOOKUP is delivering inaccurate data | Excel Worksheet Functions |