I have a spreadsheet with all '09 sales by item type. I have a pivot table chart set up, and I am printing a line graph of sales over time 1 item type at a time. I will have to do this 700x to print out each graph. Is there a way to have excel print each graph individually without me having to manually click the drop down on the pivot chart and uncheck one/check the next?
Bookmarks