How do I create a Stacked Bar Chart with the same series/color appearing multiple times?

[NYCSWE]

I'm in the process of creating a report where I want to display a sequence of events. The same event will occur multiple times and needs to be of the same color. Excel is giving me a unique color for each event...how do I work around this? Please see the link to my question at Microsoft with table and picture.


http://answers.microsoft.com/en-us/...nd-color/3ecbc753-6916-444f-b429-33b5b81f6cae


I'm using Windows 10, Excel 2013...

 

[Steve=True]

Hi NYCSWE,

Yeah you will either need to set up your data in a different way or use VBA. Check out these tutorials to do what you are looking for:

pipeline-challenge-matching-stacked-bar-chart-colors-to-products-without-vba

match-product-chart-colors-to-excel-spreadsheet-cells-petes-vba-solution

pipeline-usage-chart-dons-answer

leonids-friday-challenge-answer-pipeline-usage-stacked-bar-chart

Let me know if they help!

Steve=True

 

[NYCSWE]

Found your site late last night through another post and been working on it today and just finished. Works like a charm! Thanks a bunch! (Copied the formulas from your template...)