different makers in one chart

K

Khoshravan

I am using XY (Scatter) type chart to show the blood pressure verse age of
130 people. Untill here there is no problem and I chart shows neatly.
Some of these people are male and others are female. I want to separate the
gender by color or marker in the chart, so in one glance I can understand
which data points belong to male and which to female?
Is there any solution?
 
D

David Biddulph

Make two separate data series on your spreadsheet, and plot your chart from
the two separate series.
 

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

Similar Threads

How do I create a chart out of a list, instead of number values? 3
stacked bar chart 2
Pie Chart will only Display one slice - 100% 1
Excel 2007: Default Chart Template 2
Pie Chart 2
Comparing more than two variables 2
Quickly Format Multiple Data Series in One chart 2
MS Graph Capability?? 14

Top