by Michael Alexander | 
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.
Current Highest Rated Post
- Video: Show Chart Values without Hovering
(5.00 out of 5) - Pictures from the Xcelsius Community Event at GBN 2009 (5.00 out of 5)
Tags: Guru Videos
Interested in hiring one of our Gurus? Need help training your staff? Not sure where to start building your dashboard? We can help. Contact us to find out more!
Categories
Tags
About Us
Subscribe
English
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
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
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.
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!
This is one awesome post.Really thank you! Want more.