rush2rajen
Member
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
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