Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Reports _ Bar Graph With Conditional Colors

Posted by: sorbit Nov 8 2019, 04:25 PM

Happy Friday!

I have an Access Report that shows weeks and the number of completions by week. I want to make a graph (bar chart) that shows a yellow bar if the week number is 2 (2nd week of month) and percent complete is less than 30% and green if it's greater than 30%. For the week 3 bar graph, I would like it to display a yellow bar if the percentage is less than 70, and green if it's greater than 70. Weeks 1 and 4 would display another color. The source looks something like this:

AvgHistory AvgHistoryCompletions CurrMthCompletions MthTotal MyPerc Week2Status Week3Status
1 10.70 12 228.22 5.26%
2 50.30 34 228.22 14.90% Yellow
3 47.10 21 228.22 9.20% Yellow
4 77.30 44 228.22 19.28%
5 50.00 32 228.22 14.02%

Does anyone know if this can be done?
Thanks,
Sorbit-

Posted by: strive4peace Nov 9 2019, 09:44 PM

hi Sorbit,

Will something like this work for you?
It uses conditional formatting for the colors and the bars were made using

CODE
   BarGraph: String([MyPerc]*100,ChrW(9608))


The first image uses the numbers in your example. The second image shows results from conditional formatting for 2 when the number is changed to more than 30%.