Changing colours on a bar chart according to value

[SammiH]

Hi,
I am very new to access and have created a database based on performance against targets over time in connection with work, but I am very much isolated and have done most of it with little training / help. Most of it I have done by reading these forums and trial / error!
I have a report with performance plotted as a bar and the target as a line against X axis of month and y access of % (or £ etc). I would like the bar to change colour so that it is green if it has met the target or red if it has not met the target. This is doubly complicated as some performances have to be greater-than target and some have to be less than to meet target - I have recorded this in a field called "Target Indicator" (which has wording "Greater then or equal to target" or "Less than or equal to target). I have done some Iif codes in another report to create smiley faces depending on whether the performance is less than or equal to target and if this matches the Target Indicator field - therefore true or false. The smiley faces are based on the true or false test. Do I do something similar for the charts? What code would I need to put in?
Sorry, but any replies would need to be really clear and basic, as I have not really ventured into the programming world!
Thanks

 

[shez]

i know how to do what you want in access 2007 AND USING reports (textual) so if you want me to give it a try attach your database & lets see if i can do similar with graphs!

i just spent some minutes creating a test graph and no i cant do it with graphs! well not easy way!

 

[SammiH]

Thank you for offer, but it is a database I use at work and it contains restricted data, so I can't send it to anyone. I'm wondering if in the graph query, I can produce a calculated field to show 'true' or 'false' for met target, then get the graph to look at this field in a vba code? Sorry if I don't make sense.

 

[shez]

It does make sense and but i dont know how you would code that!

I have been playing around with my test chart i created using pivot chart and in the design mode, i am able to add condition however when I view the pivot chart, it isnt obeying those conditional formatting :s

(did you create your chart using PIVOT CHART option or just inserted a chart using "insert chart option" you get when you design a form/report etc? )

 

[SammiH]

I used insert chart - I have Access 2000 premium and I can't see a 'pivot chart' option.

 

[SammiH]

Ok - seems this is quite a complicated request! I'm still trying! Does anyone know if I should put the calculated true/false field in the graph query or in the underlying report query? I have put it in the report query, but then I get 2 graphs - one showing the "trues" and one showing the "falses". Haven't managed to link this to graph colour yet though.

 

[SammiH]

Someone please help me on this, as I am now tearing my hair out and have a deadline to work to!