Results 1 to 3 of 3

Thread: Copy and paste a Pivot Chart

  1. #1

    Copy and paste a Pivot Chart



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Can you tell me how to copy and paste a pivot chart to another workbook without loosing its formatting? (And not paste as a picture), Thanks,

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Will you be applying to new data?

    Check this article: http://peltiertech.com/copy-pivot-ta...k-to-new-data/


  3. #3
    I read this article earlier today and tried it. It works for copying the information but does not keep the same formatting, i.e. my copied pivot chart turns all my subcategories into on big label instead of how it was before whivch was more visually appealing for presentations.

Posting Permissions

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