Format Data Series in a Chart

J

Jennifer

I have a chart listing year of degree and title with salary information, I
would like to now color code the male and female different colors, how can I
do this?
 
D

Duke Carey

How does your data designate gender?

M/F?
Male/Female?
some other code?

So long as the data contains info that allows you to differentiate, just use
Conditional Formatting

Let's say the first row of data you want to address is in row 2, and that
the male/female code is in column F

Select cell A2 then highlight the entire range of data - all rows & columns
Go to Format->Conditional formatting
Select 'Formula is' and use
=$g2= "M" (or "Male" or other code)
Click on the format button and choose your fromatting atttributes
OK your way back to the Conditional Formatting dialog
Click on the Add button
Duplicate the previous steps, exect the formula is
=$g2="F"
 
J

Jennifer

In one tab is all my data with a column for 'M' and 'F', the data is pulled
into various charts and it's within those charts that I want to format the
data to be color coded. When I attempt to format the Data Series in the
chart, I do not get the conditional formatting option.... Other suggestion?
 
D

David Biddulph

Sorry. I missed the fact that you are referring to a chart. Ignore my
previous answer.

I would have thought that the best bet is to split the M and F to two
separate series, and then you can colour each series appropriately on the
chart.
--
David Biddulph

David Biddulph said:
Format/ conditional formatting. Help will tell you how.
Click to expand...
 
Top