Issue with stacked column chart: values are too big and too small

[snjpverma]

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.

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

 

[snjpverma]

Any idea on this please?