W webmax Member Dec 6, 2013 #1 Hi, i have the attached the excel sheet in the data and chart is available if add the date in the data it will automatically do the changes in chart using macro. kindly provide the macro. Attachments pivotchartmacro.xlsx pivotchartmacro.xlsx 15.9 KB · Views: 4
Hi, i have the attached the excel sheet in the data and chart is available if add the date in the data it will automatically do the changes in chart using macro. kindly provide the macro.
K kchiba Active Member Dec 6, 2013 #2 Hi webmax, you do not really need a macro, just change the data range to a Table, change the soucre of data on the pivot and refresh the pivot Attachments pivotchartmacro.xlsx pivotchartmacro.xlsx 17.1 KB · Views: 5
Hi webmax, you do not really need a macro, just change the data range to a Table, change the soucre of data on the pivot and refresh the pivot
K kchiba Active Member Dec 6, 2013 #4 Hi http://office.microsoft.com/en-001/...tables-to-manage-information-RZ102252956.aspx http://www.dummies.com/how-to/computers-software/ms-office/excel/data/using-tables.html Look at the attached link, it is a all about tables as well as how to use with pivot tables regards kanti
Hi http://office.microsoft.com/en-001/...tables-to-manage-information-RZ102252956.aspx http://www.dummies.com/how-to/computers-software/ms-office/excel/data/using-tables.html Look at the attached link, it is a all about tables as well as how to use with pivot tables regards kanti
