+ Reply to Thread
Results 1 to 2 of 2

How Do I Hide Zero Value Axis Titles where the axis is a text value and not numerical

  1. #1
    Registered User
    Join Date
    02-02-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    65

    How Do I Hide Zero Value Axis Titles where the axis is a text value and not numerical

    Hi,
    I have a bar chart with text labels on the Y axis. I essentially want to keep zero value data bars from appearing on the chart. If I try to hide the data rows with zero values, the Y axis still displays blank spaces at the end of the graph.

    Thanks to anybody that can help.

  2. #2
    Forum Contributor
    Join Date
    01-17-2012
    Location
    Canada
    MS-Off Ver
    Excel 365
    Posts
    221

    Re: How Do I Hide Zero Value Axis Titles where the axis is a text value and not numerical

    Hi Krish,

    You need to replace any occurance of zero with NA(). A simplified version would be something like (i.e. if(A10=0,NA(),A10).
    Regards,

    jeversf

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. can you hide the text which is shown on the axis?
    By dandavis1 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 11-18-2010, 09:46 AM
  2. Formulas in Chart Titles & Axis Titles
    By Bobbbo in forum Excel General
    Replies: 1
    Last Post: 05-20-2010, 02:02 PM
  3. Replies: 1
    Last Post: 01-29-2009, 04:54 PM
  4. [SOLVED] axis titles on both sides
    By Adam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2006, 05:45 PM
  5. chart axis Titles
    By seedbankstudy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-05-2005, 01:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1