Conditionally Format Data Points in Line Chart

S

Steve Krieger

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top