Hello. I followed all the steps in the lectures and searched everywhere, but I still do not understand why the size of the chart is not adjusted as the data range changes. I am assuming the range I used for the chart is not dynamic. How can I make it dynamic without using any functions like offset? Thank you!

Hi Manizha, thanks for reaching out! I'm sorry to say that I don't think I've seen this problem before. Could you add a screenshot of your tables calculation and your YtD column calculation equation? Thanks in advance! Best, 365 Eli

Follow this topic

Manizha Khairiddinova

Last answered:

12 Jan 2023

Posted on:

05 Jan 2023

Dynamic range - dynamic chart

in The Complete Data Visualization Course with Python, R, Tableau, and Excel / Dashboard in Excel - Charts – Clustered Bar Chart I

1 answers ( 0 marked as helpful)

Elitsa Kaloyanova

Instructor

Posted on:

12 Jan 2023

Dynamic range - dynamic chart

Submit an answer

related questions