“Upside-down” Chart in Excel 2010
Recently we upgraded our users to Office 2010. A user reported that some of the charts in an existing Excel spreadsheet were “upside-down” when saved in the new format. Looking at the spreadsheet the chart looked similar to this:
It wasn’t that the chart was rotated upside-down but that the wrong value was being used as the starting point for the bars. For example, instead of the bar for Jan-11 starting at 0 & going up to 20, the bar starts at the highest value & goes down to 20. The fix is pretty simple it just took me a little bit of hunting around.
Right click on the Y axis (the area in red in the image above) & select “Format axis”. Select “Axis Options”. In the “Horizontal axis crosses” section select Automatic & click OK. The chart should now look correct.
In the case of the user’s chart, in the “Horizontal axis crosses” section the user had selected…I mean, somehow “Axis value” was set to 2.0E96 which is 2,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000. That means that the bar started at that value (which is slightly off the top of the chart) & went down to the correct value.