Title:
Beyond Excel:Add Drilldown to Excel Charts Part 1 Before_DoubleClick Event
Video:
Description:Part 1 Shows how one line of VBA code adds drilldown to any PivotChart. Download code at: dl.dropbox.com Part 2 Improves on Part 1's "quick and dirty" approach by adding formatting and keeping all drilldown results to just one worksheet (where as Excel's Pivot Table drilldown adds a new worksheet for each drilldown event).
Published:
09/Feb/2011
Beyond Excel:Add Drilldown to Excel Charts Part 1 Before_DoubleClick Event
Video:
Description:Part 1 Shows how one line of VBA code adds drilldown to any PivotChart. Download code at: dl.dropbox.com Part 2 Improves on Part 1's "quick and dirty" approach by adding formatting and keeping all drilldown results to just one worksheet (where as Excel's Pivot Table drilldown adds a new worksheet for each drilldown event).
Published:
09/Feb/2011
Thanks for republishing my work. While not required, it is customary to credit the author.
ReplyDelete