S
SammiH
Hi,
I have managed to create a chart showing performance (in bars) against
target(a line) over the period of a year in months by using the chart wizard
and then trial and error! I would like the bars to be green if they are on
target and red if they have not met the target. Sometimes the performance
has to be less than target to have met it, sometimes it has to be greater
than. I have a field called "Target Indicator" to show which category it
falls into. I have used Iif statements in a normal report where I have
managed to insert smiley faces, with a true/ false test, but how do I get the
chart to change colour? I'm not very familiar with codes etc, so any very
basic instructions would be appreciated!
I have managed to create a chart showing performance (in bars) against
target(a line) over the period of a year in months by using the chart wizard
and then trial and error! I would like the bars to be green if they are on
target and red if they have not met the target. Sometimes the performance
has to be less than target to have met it, sometimes it has to be greater
than. I have a field called "Target Indicator" to show which category it
falls into. I have used Iif statements in a normal report where I have
managed to insert smiley faces, with a true/ false test, but how do I get the
chart to change colour? I'm not very familiar with codes etc, so any very
basic instructions would be appreciated!