Excel Not Offering 3rd Set of Data for 3rd Line in Combo Chart

[JST_Toronto]

Not sure if this makes sense but I have a very simple chart

2021 and 2022

Units

Days On Market

Price

When I select the data and make a column chart of any kind, I am unable to change to combo and see the PRICE at all when wanting to make that data into the LINE graph.

I want the Price which goes UP over the 2 years, to sit over the columns with the other units but excell doesn't see it.

[#2]

Hi @JST_Toronto 

I attached a sample image with 2 or more scales (3 scales as in your case). Data refresh in the chart automatically as you change your data selection.

You can check here for Microsoft Excel & Office 365.

And if you are comfortable with Google Sheets, you can find it here.

Thanks