I will get the obligatory "long time reader, first time poster" comment out now.
Create a new Excel 2010 workbook. Create a small series of numbers, some negative, some positive, for example:
Data Dater Dated Positive 15 34 11 Negative -5 -39 -7
Highlight data, insert column chart, 3-D clustered column.
See that 50 shades of grey line horizontally across the middle? That is the vertical (value) axis line. I'd like to get rid of it. It rears its ugly head whenever the value of zero is not at the bottom of the vertical axis in your precious chart. 2007 has the same issue, yet in 2003 this is not a problem.
"Aha" you say! Change chart type, 2-D column, high five!
Nope, marketing type peoples like their charts in 3-D, TYVM.
Oh ... format the vertical axis so that the floor crosses at the minimum major vertical axis value, boom!
That's one fugly chart you've got there; since we have negative numbers and all, everything looks positive.
Oh ... chart tools, Axes, Primary vertical axis, None. Problem solved!
Not really, you just removed those vertical axis numbers, which we need.
Oh ... create a text box of numbers along the left side, victory is mine!
Possibly, but this gets linked to Powerpoint monthly and the numbers change enough to make it fairly difficult to people that just want to open it and press the fancy print button in the quick access toolbar since hiding it under File is too complex.
I'm probably overlooking something very simple and missing it OR this has already been answered elsewhere. If so, I apologize. All I need is that grey line gone without changing anything else in the 3-D column chart.
I invoke the power of the interwebs to assist. Interweb powers, activate!
Bookmarks