Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Pivot Table Charts

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to preserve the formatting of a pivot table chart when refreshing data.

    I am familiar with preserving the format for the PivotTable itself, but when I refresh the pivot table I lose all many of my settings in the pivot chart.

    For example:
    Chart type & Series formatting

    Your help is appreciated.

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No, not if you are refreshing from a query or other dynamic source. What I have done, is write a macro to reformat and place a button on the graph to execute it

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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