Format Data Series in a Chart
 

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?

--
Thanks!
-Jennifer

Format Data Series in a Chart
 

Format/ conditional formatting. Help will tell you how.
--
David Biddulph

"Jennifer" wrote in message
...
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?

--
Thanks!
-Jennifer

Format Data Series in a Chart
 

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"

"Jennifer" wrote:

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?

--
Thanks!
-Jennifer

Format Data Series in a Chart
 

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?
--
Thanks!
-Jennifer


"Duke Carey" wrote:

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"

"Jennifer" wrote:

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?

--
Thanks!
-Jennifer

Format Data Series in a Chart
 

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" <groups [at] biddulph.org.uk wrote in message
...
Format/ conditional formatting. Help will tell you how.
--
David Biddulph

"Jennifer" wrote in message
...
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?

--
Thanks!
-Jennifer