I've recently began messing with charts in access, more specifically Pie Charts, and I've been experiencing a number of issues. Each of these charts are just meant to display the percentage of "High", "Medium", and "Low" in different columns.
Some don't display percentages properly, giving each category a seemingly random value. For example, two of my charts are showing roughly 33% for all three values, but "Low" should be at 0%.
Some aren't displaying colors properly. For example, if "Low" is not present, it sets the color for "Low" to "Medium" instead.
There are a few other issues that I won't get into right now.
What I want to know is, is there a simple way to set values to these charts? Right now, I have Union Queries set as the source for the charts, each of which is set up exactly the same only referencing different fields (which all only include "High", "Medium", and "Low"), and each is experiencing different issues.
I just want to display a few pie charts that show how many records are rated as "High", "Medium", or "Low".
If the most efficient way of doing this is what I did (Union Queries) then I'll post the row sources and SQL in question. Otherwise, if someone could please help me, I would greatly appreciate it. These charts have been causing me problems for a while now.
Some don't display percentages properly, giving each category a seemingly random value. For example, two of my charts are showing roughly 33% for all three values, but "Low" should be at 0%.
Some aren't displaying colors properly. For example, if "Low" is not present, it sets the color for "Low" to "Medium" instead.
There are a few other issues that I won't get into right now.
What I want to know is, is there a simple way to set values to these charts? Right now, I have Union Queries set as the source for the charts, each of which is set up exactly the same only referencing different fields (which all only include "High", "Medium", and "Low"), and each is experiencing different issues.
I just want to display a few pie charts that show how many records are rated as "High", "Medium", or "Low".
If the most efficient way of doing this is what I did (Union Queries) then I'll post the row sources and SQL in question. Otherwise, if someone could please help me, I would greatly appreciate it. These charts have been causing me problems for a while now.