Forum Discussion

Frlaflamme's avatar
Frlaflamme
Copper Contributor
Apr 05, 2022

Graph: auto matching dual "y" axis with different units

Hi there,    I'm working on a graph resulting from a table and my objective is: when I modify the data in the table, I want both y axis (primary y axis is in millions and the secondary y axis is in...
Charting
excel
office 365
Qaiser_j's avatar
Qaiser_j
Brass Contributor
May 26, 2022

Hi Frlaflamme 

 

I attached a simple image with 2 different vertical scales (The left one with the amount and the right one with age). 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

 

 

  • JonPeltier's avatar
    JonPeltier
    MVP
    May 26, 2022

    Qaiser_j 

     

    How does this help? The OP states that he doesn't want to manually recalculate and adjust the axis scales when the data changes.

Resources