sinfulon6strings
New Member
- Joined
- Feb 12, 2013
- Messages
- 1
Hello my fellow Excel enthusiasts.
I've put together a dashboard with three charts:
1) Bar Chart
2) Line Graph
3) Pie Chart
I'm tracking sales figures in total, over time, and the makeup of those sales (what products were sold) in the three charts, respectively.
As of now, I'm controlling the data via a number of slicers - the information is based on the results of HUNDREDS of different stores and the data is ranked as follows:
1) Division
A. Region
1) District
a) Store
So i can see all my data at division level, region, district, store or multiple combinations - the information all populates correctly in my dashboard via the slicers.
Now here is my problem and where I'm looking for some help/advice.
I'd like to be able to (for the sake of my non-excel coworkers):
1) Save each full dashboard view as a PDF, at the store level, while displaying information (perhaps in the file name) as to which store is being showcased.
Has anyone ever done this? Is there a better way to think of it? In my head it seems that I'd have to limit my slicers to one (store level) and have a macro cycle through each store and save each one (or multiples) in PDF format.
Unfortunately, I haven't any experience creating my own VBA code..
I've put together a dashboard with three charts:
1) Bar Chart
2) Line Graph
3) Pie Chart
I'm tracking sales figures in total, over time, and the makeup of those sales (what products were sold) in the three charts, respectively.
As of now, I'm controlling the data via a number of slicers - the information is based on the results of HUNDREDS of different stores and the data is ranked as follows:
1) Division
A. Region
1) District
a) Store
So i can see all my data at division level, region, district, store or multiple combinations - the information all populates correctly in my dashboard via the slicers.
Now here is my problem and where I'm looking for some help/advice.
I'd like to be able to (for the sake of my non-excel coworkers):
1) Save each full dashboard view as a PDF, at the store level, while displaying information (perhaps in the file name) as to which store is being showcased.
Has anyone ever done this? Is there a better way to think of it? In my head it seems that I'd have to limit my slicers to one (store level) and have a macro cycle through each store and save each one (or multiples) in PDF format.
Unfortunately, I haven't any experience creating my own VBA code..