PC Review


Reply
Thread Tools Rate Thread

Different color for data sub-set for bar chart.

 
 
=?Utf-8?B?UGV0ZXIgU3QuIEpvaG4=?=
Guest
Posts: n/a
 
      16th May 2006
I have created a vertical bar chart with 2 bars for each of 5 years showing
comparison data. For the first year, I would like to have the color of one
of the bars different from the color in the subsequent 4 years to show
special program initiation. Is there a way to do this?
--
PStJ
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      20th May 2006
Click on the series, then click on the point, then select Selected Point
from the Format menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"Peter St. John" <(E-Mail Removed)> wrote in message
news:9E005FA4-964A-42A9-96D0-(E-Mail Removed)...
>I have created a vertical bar chart with 2 bars for each of 5 years showing
> comparison data. For the first year, I would like to have the color of
> one
> of the bars different from the color in the subsequent 4 years to show
> special program initiation. Is there a way to do this?
> --
> PStJ



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Multiple-Color Data Series into One Bar Chart JSF Microsoft Excel Charting 0 24th Sep 2008 01:41 AM
Change Pie Chart segment color based on value in source data Doug Microsoft Excel Charting 2 2nd Mar 2008 04:12 PM
can i chart my data in the font color? =?Utf-8?B?bGFycnk=?= Microsoft Excel Charting 1 11th Jun 2005 03:57 PM
Bar chart fill color selection from reference to cell data Darryl Microsoft Excel Charting 1 17th Sep 2003 01:25 PM
Chart data series background color Terry Deever Microsoft Excel Charting 1 2nd Aug 2003 09:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:02 PM.