![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |