Forum Discussion
darentengmfs
Post Prodigy
Post ProdigyAlternate Bar Colors for each group
Hello, I'm trying to create a bar chart that has alternating colors for each main group, where when drilled down the hierarchy, the alternating colors apply to the main group as well. Example bel...
darentengmfsPost Prodigy
Post ProdigyHi
This works for most scenarios, thank you.
However, there is a scenario where it doesn't work. Using the new data below for example (added a new column)
| Group | Date of Transaction | Sales | Quantity |
| A | 1/1/2022 | 150 | 5 |
| A | 1/1/2023 | 123 | 6 |
| A | 1/1/2024 | 122 | 2 |
| B | 1/1/2022 | 174 | 4 |
| B | 1/1/2023 | 198 | 8 |
| B | 1/1/2024 | 130 | 4 |
| C | 1/1/2022 | 176 | |
| C | 1/1/2023 | 199 | |
| C | 1/1/2024 | 124 | |
| D | 1/1/2022 | 185 | 1 |
| D | 1/1/2023 | 188 | 6 |
| D | 1/1/2024 | 172 | 4 |
| E | 1/1/2022 | 144 | 2 |
| E | 1/1/2023 | 125 | 7 |
| E | 1/1/2024 | 133 | 3 |
When I create a chart based on Quantity column, the columns B and D do not alternate because C exists, but the data is null
Any way we can prevent that from happening?
lbendlin
Super User
Super User