+ Reply to Thread
Results 1 to 10 of 10

Pie Chart slice colours from data series

  1. #1
    Registered User
    Join Date
    10-26-2012
    Location
    Wirral
    MS-Off Ver
    Excel 2016
    Posts
    12

    Pie Chart slice colours from data series

    Hi, I'm creating some pie charts that have colour coded data series. Is there a way to get excel to use the colours in the data series for the corresponding slice in the pie chart? I can manually change the slice colours, but I'm thinking that there must be a way of getting excel just to use the colours in the data series instead of its default colours, but I can't figure it out.

    It's excel 2016.

    Any help appreciated.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,135

    Re: Pie Chart slice colours from data series

    What exactly do you mean by "colours in the data series"? Font colour? If so, you can do it with code.
    Rory
    Days when we raged, we flew off the page
    Such damage was done

  3. #3
    Registered User
    Join Date
    10-26-2012
    Location
    Wirral
    MS-Off Ver
    Excel 2016
    Posts
    12

    Re: Pie Chart slice colours from data series

    It's cell colour. Each line in the data series is coloured: green, amber red, for example and I'm trying to get excel to use those colours for the corresponding pie slice.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,135

    Re: Pie Chart slice colours from data series

    You'll need code then, assuming the colours aren't static.

  5. #5
    Registered User
    Join Date
    10-26-2012
    Location
    Wirral
    MS-Off Ver
    Excel 2016
    Posts
    12

    Re: Pie Chart slice colours from data series

    Do you have any pointers to anywhere I can find an example of the code that does it so that I can play around with it?

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,135

    Re: Pie Chart slice colours from data series

    If you post a workbook, I'll write you some? Although it goes against my nature to assist someone with pie charts.

  7. #7
    Registered User
    Join Date
    10-26-2012
    Location
    Wirral
    MS-Off Ver
    Excel 2016
    Posts
    12

    Re: Pie Chart slice colours from data series

    Thanks very much. It's appreciated.

    Regards
    Attached Files Attached Files

  8. #8
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,135

    Re: Pie Chart slice colours from data series

    This will update the first chart on the active sheet, for example:

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    10-26-2012
    Location
    Wirral
    MS-Off Ver
    Excel 2016
    Posts
    12

    Re: Pie Chart slice colours from data series

    Brilliant! Thanks very much for your help. Really appreciate it.

  10. #10
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,135

    Re: Pie Chart slice colours from data series

    Glad to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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