Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
regarding allocation of chart series point colors
Greetings and thanks for your time
I have labels A,B,C,D and data series of values a%, b%, c%, d%. This series is sorted into ascending order of values and feeds a bar chart (ie a Pareto chart). I would like to display this data also on a Pie chart, but would like to keep the same series point color for A,B etc. regardless of how the updated values change the rank order (say, C,B,A,D). Presently, if say, point A is dark blue at the start of the order and then after updating the % scores point A moves down to 3rd in the order, point A will take on another color. Any advice will be appreciated |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
regarding allocation of chart series point colors
I know I hate pie charts, but I did write this article:
http://pubs.logicalexpressions.com/P...cle.asp?ID=390 Scroll down near the end to "Color by Category Label (Conditional Formatting)" The ColorWedges procedure works also for a column chart. Change the AAAA, BBBB placeholders in the code to match your labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "David" wrote in message ... Greetings and thanks for your time I have labels A,B,C,D and data series of values a%, b%, c%, d%. This series is sorted into ascending order of values and feeds a bar chart (ie a Pareto chart). I would like to display this data also on a Pie chart, but would like to keep the same series point color for A,B etc. regardless of how the updated values change the rank order (say, C,B,A,D). Presently, if say, point A is dark blue at the start of the order and then after updating the % scores point A moves down to 3rd in the order, point A will take on another color. Any advice will be appreciated |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
regarding allocation of chart series point colors
Thanks for your time Jon
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
Refresh the series in the chart... | Excel Discussion (Misc queries) | |||
Hiding a non-plotted chart series in legend | Excel Discussion (Misc queries) | |||
create chart from series grouped by value in another column | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel |