Debraj
Excel Ninja
I just have notice, There was a 'ASSIGN MACRO' option available in the Chart Area.
I have an Idea for DASHBOARD. Is this possible add a event to any data Series, so that it can zoom the record,
i.e: Parent Chart will give the information for 'Joseph'(Sales Person), and on click of 1st DataSeries, chart changes itself to to 'Joseph * (East,West,North,South)' and a back button to view the Parent chart again.(Inspired by http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/)
I have an Idea for DASHBOARD. Is this possible add a event to any data Series, so that it can zoom the record,
i.e: Parent Chart will give the information for 'Joseph'(Sales Person), and on click of 1st DataSeries, chart changes itself to to 'Joseph * (East,West,North,South)' and a back button to view the Parent chart again.(Inspired by http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/)