[X]My Assistant

[sorbit]

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-

[strive4peace]

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%.


This post has been edited by strive4peace: Nov 9 2019, 09:57 PM

Attached File(s)

 barGraph_conditionalFormatting.png ( 7.4K )Number of downloads: 2
 barGraph_conditionalFormatting_green_s4p.png ( 7.29K )Number of downloads: 1