+ Reply to Thread
Results 1 to 5 of 5

Change default pie chart colors in recorded macro 2010

  1. #1
    Registered User
    Join Date
    03-09-2014
    Location
    Portland, OR
    MS-Off Ver
    Excel 2010
    Posts
    5

    Change default pie chart colors in recorded macro 2010

    Hi I am working on a project where I am virtually almost finished except for a minor change with the pie chart. I am analyzing some data and recorded a macro to do this and also the pie chart for visualization. However, I do not like the color of the default pie chart colors and would like to customize it. How could I change this within the macro I have recorded? I have attached my code below and any help would much appreciated. Please let me know if you have any questions or need clarifications.
    Please Login or Register  to view this content.

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

    Re: Change default pie chart colors in recorded macro 2010

    Your profile says xl2003 but that code is not for xl2003 charts. What version are you actually using?

    Did you try recording macro when changing the colour of the pie chart slices?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-09-2014
    Location
    Portland, OR
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Change default pie chart colors in recorded macro 2010

    Hi Andy, appreciate you replying. Im currently using Excel 2010. Im somewhat of a newbie and still learning macros as is hahhaa. The default colors on the pie charts are random and not exactly what I wanted. I would like to know if there is a way I could customize the colors and run a macro where its consistent with the labels I have. If theres a way to do that, that would be awesome. Thanks and appreciate your time.

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

    Re: Change default pie chart colors in recorded macro 2010


  5. #5
    Registered User
    Join Date
    03-09-2014
    Location
    Portland, OR
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Change default pie chart colors in recorded macro 2010

    Thanks Andy, Ill take a closer look and see if I could figure it out. Appreciate your help and let me know if theres anything I could do to help you with anything.

+ 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. Excel 2010 - change default chart color order
    By robhumbug in forum Excel General
    Replies: 3
    Last Post: 04-07-2015, 01:47 AM
  2. Change default colors for column chart?
    By handerson0603 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-03-2012, 03:39 PM
  3. Chart default colors in 2007
    By oucivileng in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-21-2011, 11:27 AM
  4. Change Excel palette default colors...
    By noliveira in forum Excel General
    Replies: 3
    Last Post: 03-19-2008, 05:56 AM
  5. [SOLVED] chart default colors
    By wendyeyes in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-30-2005, 12:05 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