Forum Discussion

JST_Toronto's avatar
JST_Toronto
Copper Contributor
Mar 18, 2022

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

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.

Charting
excel

1 Reply

  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    May 26, 2022

    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 https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr.

     

    And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr.

     

    Thanks

     

     

Resources