Problems creating form - first time use

[albaker]

I'm using Access 2016, and I've created a query that results in the table below. I'm trying to get the data to look somewhat like the depiction below, but I'm not having any luck. I've look at many, many posts and watched various YouTube videos, and I can create some simple bar graphs but nothing like this. Can anyone give me some pointers? This is my first time to create a form, and it's getting a bit frustrating. Thank you.

[Micron]

IMHO if a chart is what you're after then this is a job for Excel, especially since your query result resembles a spreadsheet anyway. Database information should be tall (in rows) not wide. Did you study normalization before beginning this task? Anyway, Access charts are only slightly better than having sand in your eyes, and what you show looks like you're playing with coloured rectangle widths, which just doesn't make sense to me (for this job).

[June7]

Access charting has always been adequate for my needs but what you show is not a conventional chart. Not even sure Excel could produce it.

[isladogs]

I agree with June. This isn't a chart and its certainly a very complex thing to try for a first form.
You could use code similar to that in progress bars for your % 'shading' but with 15 of these, it may be slow

Also I'm unclear how the shaded portion and % values match up or indeed what the % values refer to.

Also, like Micron I wonder what the underlying data looks like as your query layout isn't a crosstab.
Is your data normalised? Or is it in a spreadsheet layout?

[June7]

Think I have seen a 'progress/percentage bar' emulated by setting BackColor of a set of textboxes. Don't remember much about it but probably involved Conditional Formatting.

[isladogs]

A progress / percentage bar usually involves using one coloured box behind the text whose width depends on specified criteria.
When used as a progress bar the width increases as each step of the procedure is completed
In the example here its width would just be specified from the data values so very simple to implement.
No conditional formatting needed ....unless you want the colour to change depending on the value

However as already stated the screenshot indicates there are 15 of them needed - it could possibly take a few seconds to complete

There are probably hundreds of examples of progress bars available online.
Here is my take on this: http://www.mendipdatasystems.co.uk/p...bar/4594424316

[albaker]

Thanks for all the feedback. As you can tell, I don't deal with databases much, but I have a ton of info I'm trying to boil this down into a dozen or so charts like the above. I have a lot of things to consider, and I appreciate the guidance.