Dashed Gridline

Originally Posted by teylyn

Hello,

the chart uses a pattern fill for the grid line. Pattern fills are available in Excel 2003, but no longer in later versions.

If you can get your hands on Excel 2003 or earlier, you should be able to re-create the effect.

cheers,

Originally Posted by teylyn

I can't find any step numbers in the article. Can you pinpoint this more exactly? Again, it may be due to the change of the charting engine with Excel 2007. A LOT has changed with that version.

Originally Posted by Andy Pope

in xl2007 you can set the gridline to solid and pick your colour.
On the line style tab change the dash type to Round or square dot.

try setting the zoom to 100%. Do you still get the overflow?

Not sure I like the fact that the base line for the column and area chart is a negative value.

Originally Posted by Andy Pope

The '-' instead of zero is your number format.

Your data set does not have negative values so do not worry about axis crossing.

Add a border to the columns

Thanks again Andy. But I'm not able to get rid of that -. Even a "-" gets plotted in the data labels.
Is it because the array formulas can't be a blank? If i delete the array formulas for the blank cells in "Monthly Average Profit" the data labels don't show "-", it just shows on the one wehre there is a number.

But I still get the negative "-" instead of 0 at bottom left.