Results 1 to 2 of 2

Thread: Pivot Charts

  1. #1
    New Lounger
    Join Date
    Nov 2003
    Thanked 0 Times in 0 Posts
    Is there a way I can print out multiple charts from a pivot chart which have been filtered by staff members i.e. john, mary, sarah all have different charts within the one pivot chart. The only way I have able to print them is to select staff member and then print each one separately. Is there a quicker way?

    Also is there a way to save the chart type, colour etc without have to change the excel default chart. I can make the changes to one chart but when I go to the next staff member it goes back to the default settings.

    Thanks for your time.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts
    You might use the staff member as page field and use VBA code to loop through the page items and print the chart - something along the lines of Post 539727.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts