LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Aurora
 
Posts: n/a
Default Chart not charting right

I am using Excel 2000
I have made many a chart and never have had this problem before. I hope
someone can help me.

I am charting our scrap $ as a % of our Sales. I have my table with all of
this calculated- by month for a 3 year period. My table is formated as %'s.
The % are correct. I created a simple line graph to show the %'s. The first
year graphs Ok. What I mean is that the Y axis has the % and the line points
line up with the Y axis fine. Example: 4.5% is between 0% and almost to the
5% line.

But the 2nd and 3 year do not graph correctly at all. Example: 1 month is
at 11.5% and on the graph it shows this point above the 20% line. I label
all of the points with the data to make sure that I had picked up the correct
numbers and they were all right but the line graph (for 2 years) is way off
as to where they should be on the graph.

I hope you can understand what I am trying to explain. Can anyone suggest
what I need to do to correct this? I even tried creating a new chart and it
came out the same way. HELP!!!!

Aurora
 
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
Charting data points and show a target range on the same chart. Minireefkeeper Charts and Charting in Excel 6 February 18th 06 06:50 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 08:18 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"