Conditionally Hide Chart Axis Labels

  • Is it possible to hide some of the number labels on an axis; e.g. in on the chart below to hide the X-axis label 96? Or only start numbering from 97 while the chart displays from 96.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Well I have a solution to hiding the first value on the excel X axis values labels just using a custom number format;


    [Black][>96]General;


    but is there anyway of formating more than a couple of the number labels individually?

  • Re: Hide Some Axis Number Labels


    If you want full control over values and their appearence on the axis you are better off creating them yourself. Use the data labels of a dummy series.


    Note: Will not work if you use 3d chart types.

    [h4]Cheers
    Andy
    [/h4]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!