Hello Team,
As shown in the below screenshot of the Chart that I prepared, due to values of "Grand Total" being very high the column chart of the smaller values is almost invisible. Please assist what are the various options to deal with this issue. Is there a way to show Grand Total in some other way in charts? so that the other columns get a bit bigger? I have never worked on charts before, so I don't know about other possible ways.
As shown in the below screenshot of the Chart that I prepared, due to values of "Grand Total" being very high the column chart of the smaller values is almost invisible. Please assist what are the various options to deal with this issue. Is there a way to show Grand Total in some other way in charts? so that the other columns get a bit bigger? I have never worked on charts before, so I don't know about other possible ways.
Event Report - 2023-07-02T110333.065.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | |||
3 | Type of Activity | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Grand Total | ||
4 | Sing | 33,249 | 9,584,021 | 348,249 | 15,408 | 41,926,891 | 51,907,818 | ||||
5 | Dance | 2,933,749 | 227,417,073 | 45,749 | 785,739 | 1,845,749 | 573,214,749 | 935,749 | 807,178,557 | ||
6 | Play | 1,045,749 | 31,923,928 | 530,749 | 7,114,949 | 40,615,375 | |||||
7 | Read | 8,030,259 | 75,609 | 4,624,349 | 12,730,217 | ||||||
8 | Draw | 609,032 | 21,155,424 | 689,805 | 22,454,261 | ||||||
9 | Build | 9,175,749 | 116,417,032 | 1,740,749 | 23,527,752 | 3,124,329 | 33,827,617 | 1,773,749 | 189,586,977 | ||
10 | Code | 11,777,079 | 33,049,245 | 16,804,249 | 521,449 | 41,520,925 | 85,749 | 103,758,696 | |||
11 | Grand Total | 25,574,607 | 447,576,982 | 1,786,498 | 42,072,347 | 5,506,935 | 702,919,285 | 2,795,247 | 1,228,231,901 | ||
question |