I would want to have a Drop down list with three Options - class 1, class 2, class 3
Based on the Option selected, the macro should create Pivot table for each class.Data for each of the option is available in the same worksheet (MyData)
class 1 needs pivot on column1 and column2 -> sum(column2) [Sheet MyData]
class 2 needs pivot on column1 and column3 -> sum(column3) [Sheet MyData]
class 3 needs pivot on column1 and column4 -> sum(column4) [Sheet MyData]
From the pivot tables, charts need to be created.
Chart only for the option selected.
All the charts in one sheet called (MyChart)
-Also, records are added from time to time,infact everyday. so it should work with changing data and update pivot tables and chart.
I'm extremely new to VB and have seen the forum, tried lot of macros, recording them. It isn't working.
Also, I am working on Excel 2010.
Pls help
Based on the Option selected, the macro should create Pivot table for each class.Data for each of the option is available in the same worksheet (MyData)
class 1 needs pivot on column1 and column2 -> sum(column2) [Sheet MyData]
class 2 needs pivot on column1 and column3 -> sum(column3) [Sheet MyData]
class 3 needs pivot on column1 and column4 -> sum(column4) [Sheet MyData]
From the pivot tables, charts need to be created.
Chart only for the option selected.
All the charts in one sheet called (MyChart)
-Also, records are added from time to time,infact everyday. so it should work with changing data and update pivot tables and chart.
I'm extremely new to VB and have seen the forum, tried lot of macros, recording them. It isn't working.
Also, I am working on Excel 2010.
Pls help
