Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 193
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,180
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,180
Default How to set each gruop of columns into same color?

Excel 2007
PDF preview
http://www.mediafire.com/file/q1wzgwuzmyr/03_07_10.pdf
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I use logic to gray or color other columns? Mic Excel Discussion (Misc queries) 1 October 1st 08 08:27 PM
Delete Columns and Color Cells iperlovsky Excel Discussion (Misc queries) 2 July 1st 08 10:29 PM
How to apply different color on different columns and legends easily? [email protected] Charts and Charting in Excel 1 March 19th 07 09:04 AM
Text Color Change prompted by different columns NKDodd Excel Worksheet Functions 1 August 15th 06 08:13 PM
Sort columns by color danpajo Excel Discussion (Misc queries) 1 September 1st 05 05:08 AM


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"