In the “Horizontal axis crosses” section select Automatic & click OK. Right click on the Y axis (the area in red in the image above) & select “Format axis”. The fix is pretty simple it just took me a little bit of hunting around. 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. 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. Looking at the spreadsheet the chart looked similar to this: A user reported that some of the charts in an existing Excel spreadsheet were “upside-down” when saved in the new format. Recently we upgraded our users to Office 2010.
0 kommentar(er)
