 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / October 2006regarding 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 I know I hate pie charts, but I did write this article: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.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 _______ > Greetings and thanks for your time > I have labels A,B,C,D and data series of values a%, b%, c%, d%. This [quoted text clipped - 11 lines] > color. > Any advice will be appreciated Thanks for your time Jon |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.