ExcelBanter - How to set each gruop of columns into same color?

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - How to set each gruop of columns into same color? (https://www.excelbanter.com/charts-charting-excel/258230-how-set-each-gruop-columns-into-same-color.html)

terry

How to set each gruop of columns into same color?

In my chart there is two data shown in the X-Axis--Date and Team. 2 teams per
day. Total 4 teams rotating.
How to set the same team's bar into same color? And just use 4 colors to
represent 4 teams?

Herbert Seidenberg

How to set each gruop of columns into same color?

Excel 2007 PivotTable, PivotChart
Uniquely color each PivotItem of a PivotField.
With macro.
http://c0718892.cdn.cloudfiles.racks.../03_07_10.xlsm

Herbert Seidenberg

How to set each gruop of columns into same color?

Excel 2007
PDF preview
http://www.mediafire.com/file/q1wzgwuzmyr/03_07_10.pdf

All times are GMT +1. The time now is 08:37 AM.