Ms. Compy Fix-It vs. Excel 2007’s Horizontal Axis Issues

Hi everybody! (“Hi, Dr. Nick!”)

Ms. Compy Fix-It here, with another workaround for all you folks wrestling with Excel 2007’s quirks.  This one is to do with Excel ignoring your pretty horizontal axis and deciding to do its own thing……

So let’s start off with my chart:

Image

This looks okay to me.  But say I’d done some resizing within my Whole Chart Area and things have moved around a bit.

Image

Whoops, that looks ugly!  The horizontal axis label’s on top of the legend and we can’t have that.  So, I’m going to resize the Inner Chart Area to move it up, right?  Well watch what happens.

 excel Example Pic - Post 2 - 2.1
Wait, since when did my data become negative?

I initially thought it had to do with the way I resized it.  I even drew a chart to figure out whether it was the Inner Chart Area or the Outer Chart Area resizing that made it a problem.  Turns out the problem is partially about resizing and partially about this:
excel Example Pic - Post 2 - 3

Ugh!  So then I zoomed in to 100% and it fixed my chart……… but guess what?  My other charts started messing up their horizontal axis-crossing data!

So…… turns out I don’t know a fool-proof method for getting rid of this quirk.  However, I do know that sometimes altering the Inner Chart Area and/or the Outer Chart Area can fix it, and other times the Zoom can fix it.

If you know why this is and can help us all out, please leave a comment!

Advertisements

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s