+ Reply to Thread
Results 1 to 1 of 1

refresh paste chart from another sheet doesnt change the formatting as per the sourcechart

  1. #1
    Registered User
    Join Date
    03-22-2018
    Location
    Melbourne
    MS-Off Ver
    Ms office 2016
    Posts
    18

    refresh paste chart from another sheet doesnt change the formatting as per the sourcechart

    Hi

    I have a got basic question:
    I have got pivot tables and pivot charts in the same sheet. I have copied some of the pivot charts
    to another sheet which is a dashboard sheet. so when the data changes , it refresh the pivot charts and
    the dashboard charts also refreshed as per new data, so that part is fine.

    I just changed the layout and formatting , colours for the pivot charts in my pivot table and pivot charts sheet.
    Now the dashboard sheet refresh the data in the charts however it wont change the new layout , colour etc as per the
    source pivot charts in my sheet. I have tried to copy and paste charts with source formatting or paste as picture in the
    dashboard sheet, however it doesn't change so I have to manually change the layout, colours etc .

    Is there any option that charts layout also refreshed if I change any layout in the original chart , or is there any other
    way to copy and paste these charts.
    I am using excel 2010.

    Please advise.
    thanks
    Tauqeer
    Attached Files Attached Files
    Last edited by Bondtk; 10-28-2019 at 11:58 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting does not refresh with Copy/Paste
    By Daryl K in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-19-2015, 04:09 PM
  2. Refresh Pivot chart on protected sheet
    By MeenuSaini in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2010, 08:16 AM
  3. Spinner Link Cell Doesnt Change when i Copy and Paste the Row
    By t0m46 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2010, 07:24 AM
  4. Keep Pivot Chart Formatting on Refresh
    By statenja in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-01-2009, 04:55 AM
  5. Why Doesnt This Work - Repeat Refresh
    By zordon1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2009, 09:44 PM
  6. programically refresh pivot chart formatting
    By Todd F. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2006, 01:25 PM
  7. ControlTipText in a ListBox, doesnt refresh
    By Velune in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2006, 06:56 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1