+ 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
    31

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    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

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

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    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
    31

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    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
    31

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    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
    31

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    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)

Similar Threads

  1. [SOLVED] Multiple Data lablels for one slice of the pie chart
    By ImranBhatti in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-03-2017, 09:18 PM
  2. vba to set line chart series as gradient line with two colours
    By NickyC in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-13-2017, 07:06 AM
  3. Pie Chart Slice Colors
    By BarryKSC in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2014, 04:23 AM
  4. [SOLVED] Align Line Chart's data series Data labels on top of Bar chart data series
    By rgunlimited in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2014, 10:38 AM
  5. [SOLVED] Pie Chart Help! Slice explosion?
    By pwall1115 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-13-2013, 10:29 AM
  6. breaking down a slice of a pie chart
    By ilundy77 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-24-2010, 10:35 PM
  7. Dividing a slice of a pie chart
    By sessy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-29-2009, 05:02 AM

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