Select an excel chart with drop down list | Switch between graphs

[@ExcelTipsVideos]

Check out how to get the sum of filtered data in Excel - kzbin.info/www/bejne/aZzMY3eVjKmnnLs

[@fineter]

Thank you sir.

[@spydymn5114]

how to achieve this with a dynamic table

[@ExcelTipsVideos]

Achieving this with a dynamic table ( dynamic number of rows) will require a VBA based solution. However, if you know the maximum possible number of rows, we can use a formula based approach. For example, you know that the table is dynamic but will never exceed 25 rows. You can wrap the formula in the helper column in an IF statement and drag the formula till 25th row, the formula will be like -> =IF(B2"", Current Formula in the Helper column,NA()) If value present in Year column, populate the Helper column return the value evaluated by the current formula in the Helper column If no value present in Year column, i.e. row is empty, populate the Helper column with "#N/A" Populating the values in Helper Column with NA() will prevent it from getting plotted in the chart. I have not yet tested this out - I will try and test this out and give you the exact solution in a day. Thanks and I hope this helps.

[@jamietan8002]

I like this easy to learn and simple way! Thank you for the video

[@ubaidillahmuhammad20]

nice and good job. but please always put practiced files [.*xlsx] in the video description ...

[@ExcelTipsVideos]

Thanks for the suggestion

[@biratroy9519]

thank you sir. This really helped me a lot. I was looking for something like this for days😭😭😭

[@ExcelTipsVideos]

Thank you for your support

[@GURUG1]

Subscribing your channel

[@charmin5054]

Thank you!!