Hello,
I've been trying to make a bar graph, with the y-axis up to 100%. data is something like this:
| Location | Status | % of Status Total |
| A | Not Started | 50% |
| A | In Progress | 50% |
| A | Completed | 0% |
| B | Not Started | 100% |
| B | In Progress | 0% |
| B | Completed | 0% |
| C | Not Started | 25% |
| C | In Progress | 25% |
| C | Completed | 50% |
The purpose is to see the % of each category, but I only want to see only the "In Progress" and "Completed" categories. However, everytime I filter out the data, the bar fills up to 100% again, ratios adjusted.
Eg. If I filter out Not Started, location A's bar would be 100% In progress. I want it 50% In progress (bar should be half the size). Location B's bar should be empty, Location C should be 3/4 filled.
I tried using both the "100% stacked column chart" and "stacked column chart", neither works.
Right now, I made it so the data colour for Not Started = white as a temporary solution. However, it still shows up in the legend, and only works because alphabetically, it's last on the list, so the data colours don't float. I'll need a proper solution.
Anyone have any advices? Thanks!
