Home > Computers > “Upside-down” Chart in Excel 2010

“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.

Advertisements
Categories: Computers Tags: ,
  1. AndrewM
    November 7, 2011 at 9:55 pm

    This came up as a close answer to my Google search for “excel chart logarithmic upside down”. Thanx for pointing me in the right direction. Excel Mac 2008 likes to make the Horizontal axis cross at your max value, not 0. So my log axis from 0-100% was upside down. Change ‘Horizontal axis crosses’ to 0 and all’s well.

    • patrickhoban
      November 8, 2011 at 10:02 am

      Glad I could help even a Mac guy. šŸ™‚

  2. Djelke
    June 12, 2013 at 11:02 am

    Thanks for the help

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: