Trouble Giving Unique Formats to Graph Y-Axises That Changes with Combo Box

Hello all,

Like the title says I am having trouble getting the format of my Y axis on a dynamic chart to have unique formats for the selected unit. I have made many charts like this before and I am pretty sure Excel's default is to allow this "action" when you change this information in

right click > Format Axis > Number > Category... etc.

However, for this graph when I change my combo box to my currency variable (for example), then follow the above process to format it as Currency, every other y axis in the combo box changes to currency.

And yes all of the columns that my =OFFSET functions are referring to are properly formatted in the unit that I would to be displayed in my chart.

Does anyone know how to fix this?