Adjusting Clustered Column to Enhance Smaller Numbers

[akvpv6]

I need assistance in manipulating the visuals on the attached clustered column chart. As you can see on the side axis the minimum and maximum units are larger due to one set of data requiring a much larger number set (count) than the other (headcount).

Is there a way for the headcount bars to look larger so they aren't basically invisible on the graph, while keeping the count bars as close to how they appear currently? I have included the data sample as well below.

FY	Count	Headcount
FY14	2997​	5​
FY15	3665​	5​
FY16	5110​	5​
FY17	5933​	6​
FY18	6339​	6​
FY19	8640​	6​
FY20	9669​	6​
FY21	8138​	7​
FY22	11037​	7​
FY23	11459​	7​
FY24	12334​	7​

 

[hagia_sofia]

I am not sure if it is possible to post an external link here but look for "Add or remove a secondary axis in a chart in Excel" - this should solve your problem with visualisation.

 

[akvpv6]

I am not sure if it is possible to post an external link here but look for "Add or remove a secondary axis in a chart in Excel" - this should solve your problem with visualisation.

I did try with a secondary axis however I am not trying to have the headcount as a line and when you select anything else other than a line it messes up the main chart

 

[hagia_sofia]

I see. Well, then you could e.g. multiple the Headcount by 1,000, create another column with original Headcount values and then select "Values from Cells" in Label Options...

 

[akvpv6]

I see. Well, then you could e.g. multiple the Headcount by 1,000, create another column with original Headcount values and then select "Values from Cells" in Label Options...

do you mind elaborating on this? I feel like this might work but I am unsure on how I would select the correct data if there is two headcount columns

 

[hagia_sofia]

What I mean is that you select clustered column chart with 2 categories (yellow) and then in Label Options select "Value from Cells" for the "Headcount" and select the corresponding data (blue).

 

[akvpv6]

What I mean is that you select clustered column chart with 2 categories (yellow) and then in Label Options select "Value from Cells" for the "Headcount" and select the corresponding data (blue).

Bingo! that worked, thank you!