View Single Post
  #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