+ Reply to Thread
Results 1 to 2 of 2

Copying the chart - will not change the color to default and the data will not include $

  1. #1
    Forum Contributor
    Join Date
    02-16-2012
    Location
    Denmark
    MS-Off Ver
    O365
    Posts
    256

    Copying the chart - will not change the color to default and the data will not include $

    Hi,

    I have a database where pie charts will show every month - 3 years span

    I tried to copy paste it but whenever I do it, the color changes to default and the data has $ in formula so the formula "does not follow" the row.

    For examplein column AT7 - I copied it in column AT9:

    a. chart color changes to default

    b. char data formula is: (is constant)
    =Summary_with_Chart!$AQ$5:$AS$5;Summary_with_Chart!AQ8:AS8
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Copying the chart - will not change the color to default and the data will not include

    Chart references are always absolute (unless you use named ranges). And do not update automatically when you copy chart and data. If you copy the sheet then any chartobjects on it referencing the sheet will update to the newly copied sheet.

    In a simple test a pie chart with custom colours retained those colours when copying. So not sure why you chart is reverting to defaults. You may have to reformat the newly copied chart. It is possible to copy the original chart and then use paste special to apply only formats to the recently copied chart.
    Cheers
    Andy
    www.andypope.info

+ 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. Replies: 9
    Last Post: 04-09-2018, 09:46 PM
  2. text color of chart to change as per data
    By siddiqsh in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-01-2015, 08:11 AM
  3. Excel 2010 - change default chart color order
    By robhumbug in forum Excel General
    Replies: 3
    Last Post: 04-07-2015, 01:47 AM
  4. chart change data series color
    By dpatel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-22-2011, 06:32 AM
  5. Replies: 3
    Last Post: 11-02-2005, 07:55 PM
  6. How do I change the excel chart default plot area color?
    By gg96555 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-08-2005, 04:06 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