A Arup Dutta Chowdhury Member Nov 15, 2019 #1 I have an excel file where there are name and month wise sale figure is given. I want to create a drop down list where so that when I select the name of the people, chart will automatically get changed. Attachments Book1.xlsx 9.6 KB · Views: 9
I have an excel file where there are name and month wise sale figure is given. I want to create a drop down list where so that when I select the name of the people, chart will automatically get changed.
Chihiro Excel Ninja Nov 15, 2019 #2 What chart? Personally, I'd just flatten out the table and use pivot table with slicers. Attachments Book1 (10).xlsx 24.5 KB · Views: 15
A Arup Dutta Chowdhury Member Nov 16, 2019 #4 Hi Chihiro I do not want to use pivot table slicer. Is there any other way to do the chart.
Chihiro Excel Ninja Nov 18, 2019 #5 Sure there is. But I've got no idea what sort of chart you are trying to do. After all, I'm not a mind reader.
Sure there is. But I've got no idea what sort of chart you are trying to do. After all, I'm not a mind reader.