May
5

Video: Conditionally Formatting Y-Axis Labels

Did you know that you can add colors to your custom number formatting in Excel?  Not only that, but you can leverage Excel’s custom number formatting to add color to all kinds of Xclesius components.  I recently produced a video demonstrating how to apply colors to Y-Axis labels based on simple conditions.  This is an easy way to add another layer of analysis to your charts without adding overhead to your Xcelsius dashboards.

Mike Alexander is the author of several books on advanced business analysis, including Crystal Xcelsius For Dummies. You can find Mike at www.datapigtechnologies.com, where he serves as principle contributor and shares free video tutorials with the Microsoft Office and Xcelsius communities.

Tags:

5 Responses to “Video: Conditionally Formatting Y-Axis Labels”

  1. Charles Davies says:

    Nice!

    Another tip I use to display coloured Y-Axis values when using the Fixed Label Size checkbox is to format the vertical Axis labels on the Appearance tab first, and change the number format to be Numeric and select negative values as Red in Perenthesis with the thousand separator. Then if you tick the Fixed Label Size checkbox, negative values keep the numeric formatting but have the K, M, B sufixes as well.

    Regards
    Charles

  2. Kalyan Verma says:

    Great tip Michael.
    I was wondering if we can give a cell reference for the Alert? For instance, can we reference a cell instead of entering 500 in the Custom Format Field?

    Regards,
    Kalyan Verma

  3. Hi Kaylan,

    Unfortunately, you are not able to reach out from the custom number formatting dialog box and reference a cell. The criteria you use has to be hard-coded.

  4. Jesse Aden says:

    Very niice!
    I know this comment comes quite a while after the original post, but I was wondering if you know how to do a good trend line in a line graph with Xcelsius.
    It would be a great help!

  5. Zane Kovac says:

    This is one awesome post.Really thank you! Want more.

Leave a Reply