Print Page | Close Window

Customized colours in graphs based on other data

Printed From: Crystal Reports Book
Category: General Information
Forum Name: New feature request
Forum Discription: Share what features you want to see in the next release of Crystal Reports.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5682
Printed Date: 03 May 2024 at 12:06am


Topic: Customized colours in graphs based on other data
Posted By: Wendy
Subject: Customized colours in graphs based on other data
Date Posted: 04 Mar 2009 at 10:47am
Hi there,
 
I am reporting on information that covers two fiscal years.   The following has been requested of me, to be presented in a graph format and in cross-tab:
 
If the data for the current fiscal year is greater than that from the previous fiscal year, change the colour to green, if it is less, then change the colour to yellow, and otherwise,  have the colour be blue.
 
I have done conditional colour formatting previously, but never by using this type of comparison.   Can this even be done?   If so, how?
 
Also, the data that is being compared are all formula fields.
 
Thanks


Replies:
Posted By: Dan3D
Date Posted: 20 May 2009 at 9:25pm
If all else fails, this functionality is easily done in our CRChart add-in, which has macros to handle multiple coloring options based on charted-values.
 
-Dan
 
DISCLAIMER: I work for the company, threedgraphics.com, that makes this product. This product costs money.


Print Page | Close Window