Forum Discussion
bobbob123
Helper III
Helper IIIConditionally Format Column Chart
Hi, I am currently working with an unstructured dataset that looks like this. It basically shows the year, the different subjects (A,B,C) and the number of students obtaining the marks ...
bobbob123Helper III
Helper IIIHi Ashish,
Here you go.
| 2022 | Subject A | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 |
| 2022 | School | 1 | 4 | 5 | 8 | |||||||
| 2022 | State | 235 | 116 | 123 | 979 | 257 | 807 | 651 | 224 | 932 | 330 | 797 |
| 2022 | Subject B | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 |
| 2022 | School | 10 | 3 | 6 | 4 | 1 | ||||||
| 2022 | State | 928 | 918 | 362 | 191 | 59 | 642 | 794 | 249 | 164 | 646 | 201 |
| 2022 | Subject C | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 |
| 2022 | School | 13 | 5 | 6 | 8 | 9 | ||||||
| 2022 | State | 113 | 822 | 72 | 787 | 378 | 917 | 880 | 494 | 303 | 134 | 259 |
Ashish_Mathur
Super User
Super User- bobbob123
Hi,
Thank you for your response.
This is a column and line graph, i need the visual to be a column graph only. Where there is an overlap with schools and state, the "column" will be displayed a different colour. I've attached an image in my post for reference.
- Ashish_Mathur
You are welcome. You can convert it to any visual you want. If you convert it to a Column chart then the School portion of the column will not even be visible because of the magnitude of difference with the State numbers.