Want to make a Sales Dashboard with Sales and Qty Figures

[rush2rajen]

Hi Excels Maters,

I am having raw data wherein Sales & Qty for each month is given respectively.
I want to make a Sales Dashboard showing how each of the Items performed in terms of sales and qty in their respective months but It should showcase in one single graph with a click of the mouse. I tried to make it with drop down in dashboard sheet but in vain.

Its a big challenge for me to show that this Dashboard is possible in excel.

Request you all to kindly go through this and suggest how can i make it ?


Thanks
Rush

 

[vletm]

@rush2rajen
Something like this ...
then You're testing Your 'drop down'

 

[Chihiro]

Something like this?

In general, I'd recommend adding overall stats on dashboard (ex. by region for all item, by item for all region, and all item & all region).

 

[rush2rajen]

Hi Chihiro

Thanks a lot. Thats what I was looking for.

Thanks
Rush