Dynamic range - dynamic chart
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Dashboard in Excel - Charts – Clustered Bar Chart I
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!
1 answers ( 0 marked as helpful)
Elitsa Kaloyanova
Instructor
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