annadupree
Board Regular
- Joined
- Mar 23, 2005
- Messages
- 51
My manager would like me to create charts for 30+ departments every month in separate files with their average weekly spend for the past year and headcount.
There are sub-departments that I've been using in the page field of a pivot chart so the manager can view total spend, or spend by sub-department. (There's a similar chart for headcount.)
Is there a simple macro that I can use that will create separate charts based on the department name?
Even better, is there a separate macro that will take each chart and save it as a separate file for distribution?
There are sub-departments that I've been using in the page field of a pivot chart so the manager can view total spend, or spend by sub-department. (There's a similar chart for headcount.)
Is there a simple macro that I can use that will create separate charts based on the department name?
Even better, is there a separate macro that will take each chart and save it as a separate file for distribution?