LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default inaccurate line chart

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
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
Cutting a line in a line chart when data series stops DannyS Charts and Charting in Excel 2 August 28th 07 10:38 AM
How do you correct inaccurate sumif totals? Analyst Excel Worksheet Functions 2 August 15th 07 11:59 PM
Getting line on line chart to display after creation from Pivot Table dcsi_jim Charts and Charting in Excel 8 February 6th 07 08:54 PM
LOOKUP is delivering inaccurate data tom Excel Worksheet Functions 7 August 29th 06 06:45 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM


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

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

About Us

"It's about Microsoft Excel"