View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Steve Krieger Steve Krieger is offline
external usenet poster
 
Posts: 3
Default Conditionally Format Data Points in Line Chart

I'm trying to create a Line Chart that shows one group of data, but displays
the points on the chart differently depending on the gender of each person
charted. For instance each data point that is male is blue and each data
point that is female is red. Here is what the data looks like:

Data
Gender % Color of Point on Line Chart
M -7.0% Blue
F -6.6% Red
M -5.5% Blue
F -4.0% Red
F -2.5% Red
F -1.0% Red
M 0.0% Blue
F 1.0% Red
M 1.5% Blue
M 2.5% Blue
F 3.0% Red
M 4.5% Blue
F 6.0% Red

I would like the % to be on the Y axis and the Gender on the X axis,
conditionally formated to be blue for M and red for F.
Is this possible? Thanks.