Different graphs on same plot of different length using drop down option

Question

Hi guys, I need to generate a graph of data sets of different lengths on same graph using drop down option. Like for instance I have monthly expenses and daily expenses and length of monthly expenses is 12 and daily expenses for a particular month is 30. So i want these separately on same graph using drop down option. Like when I click monthly I should get monthly graph and when I click daily I should get a daily graph.. Please help urgent

Answer 1

Hello SattiSubbu,

Thank you for posting to community forum.

According to description you want to create a drop-down menu for data so it can switch the data on a graph. If my understanding doesn’t match your situation, please post back and point that.

To provide a proper support can you please share a sample of your file with us? You may replace or remove the sensitive data and upload your file to OneDrive and share a link here.

If you can’t share your file, we kindly ask you to add some screenshots of how you data set look.

Meanwhile you may check these tutorials for a useful information:

Drop Down Menu with adjusting Graph // Excel Tutorial - YouTube

Excel Dynamic Chart Linked with a Drop-down List - GeeksforGeeks

How to create dynamic charts linked to a drop-down list in Excel (powerusersoftwares.com)

***Disclaimer:****Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.*​

We highly appreciate your patience and understanding.

Best Regards,

Igor