«
»

[How-To] Hide “0″ in Microsoft Excel Chart Axis

Microsoft Excel Chart axis starts with “0″ and this often doesn’t add much value. If you are looking out for a way to hide “0″ from the excel chart axis, this article will teach you that.

I have been following Pointy Haired Dilbert for getting better with Excel and i believe even you should. Its definitely a great resource for building up your Excel skills.

Steps mentioned below can be used to hide “0″ in Microsoft Excel Chart Axis

  1. Select the axis and press CTRL+1 (or right click and select “Format axis”)
  2. Go to “Number” tab. Select “Custom”
  3. Specify the custom formatting code as #,##0;-#,##0;;
  4. Press “Add” if you are using Excel 2007, otherwise press just OK.
  5. That is all.
Image: Hiding "0" in axis chart

Image: Hiding "0" in axis chart

Also Read: [Tutorial] Create Basic Charts using Microsoft Excel

You can follow me on Twitter at http://twitter.com/vaibhav1981

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

Related posts:

  1. How-To: Create Basic Charts using Microsoft Excel
  2. [How-To] Conditional Formatting Using Microsoft Excel
  3. [How-To] Shrink Excel Text
  4. [How-To] Calculate Equated Monthly Installment using MS Excel
  5. [Twitter]Hide Your Twitter Activity in a Excel Screen With SpreadTweet

This entry was posted on Tuesday, December 15th, 2009 at 9:10 am and is filed under How-To, Microsoft Excel. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply