If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Line Chart Incorrect Data Display
My data in the worksheet cell is '100%' - on the chart is plotting '118%'.
Please help. Thanks! |
#2
|
|||
|
|||
Line Chart Incorrect Data Display
Hi,
Not a lot of information to go, but try checking the line chart is not of the stacked variety. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Gingerly" wrote in message ... My data in the worksheet cell is '100%' - on the chart is plotting '118%'. Please help. Thanks! |
#3
|
|||
|
|||
Line Chart Incorrect Data Display
Hi Andy
Thanks so much for your quick response but I had read through the threads and had already checked to see if it was a stacked linear chart. It was not. I resolved the issue but probably not in the best way. When I clicked to edit the Y axis, I saw that the maximum field was set to 1.2 so I just uncheched that field and changed the value to 1.0 and it seemed to work. "Andy Pope" wrote: Hi, Not a lot of information to go, but try checking the line chart is not of the stacked variety. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Gingerly" wrote in message ... My data in the worksheet cell is '100%' - on the chart is plotting '118%'. Please help. Thanks! |
#4
|
|||
|
|||
Line Chart Incorrect Data Display
Hi,
Not sure how setting the max to 100% has solved the problem. I think you have just masked the problem by cutting the line so section above 100% is not displayed. Of course the slope of the line will still be incorrect. If you want to send example I will take a look. andy AT andypope DOT info Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Gingerly" wrote in message ... Hi Andy Thanks so much for your quick response but I had read through the threads and had already checked to see if it was a stacked linear chart. It was not. I resolved the issue but probably not in the best way. When I clicked to edit the Y axis, I saw that the maximum field was set to 1.2 so I just uncheched that field and changed the value to 1.0 and it seemed to work. "Andy Pope" wrote: Hi, Not a lot of information to go, but try checking the line chart is not of the stacked variety. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Gingerly" wrote in message ... My data in the worksheet cell is '100%' - on the chart is plotting '118%'. Please help. Thanks! |
Thread Tools | |
Display Modes | |
|
|