Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |