Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi...I'm fairly new to charting. I'm creating a line chart with years along
the category axis and dollars as values. Seems pretty simple. The data consists of 3 items: sales, expenses, and net income. When I include these 3 together and create a chart, the scale doubles and expenses and net income are shown as greater than sales. When you click the data points, though, they are accurate. For instance, the data point might be 5,000, but it's shown at the 10,000 level on the chart. In a nutshell: Sales appears right where it should be on the scale Expenses appears about double what it should be (although data point is accurate) Net Income appears about double (data point accurate) I don't get this behavior when I chart these items separately, or when I use something like a column chart. What in the world is wrong? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
How do you correct inaccurate sumif totals? | Excel Worksheet Functions | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
LOOKUP is delivering inaccurate data | Excel Worksheet Functions | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |