| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart Incorrect Data Display
My data in the worksheet cell is '100%' - on the chart is plotting '118%'.
Please help. Thanks! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Trend Line Display Error | Charts and Charting in Excel | |||
| Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
| Incorrect Data Labels on Column Chart | Charts and Charting in Excel | |||
| Incorrect date in line chart in Excel. | Charts and Charting in Excel | |||
| How to display chart with three bars and one line? | Charts and Charting in Excel | |||
Linear Mode
