EXCEL Scatter Graphs

  • Thread starter Thread starter dcinc74
  • Start date Start date
D

dcinc74

I am doing a graph for a statisrics class that involves sorting
information on bears from a collection of data I have.

I am to plot the age and weight on a scatter graph, which was no
problem, but the instructor wants us to designate which bears are male
and which are female, he suggested using X'S AND O'S.

My question is, How do I make specific symbols appear on the scatter
graph, it usually willl just show different colored plot points to
represent the data.

Thanks
 
dcinc74 said:
I am doing a graph for a statisrics class that involves sorting
information on bears from a collection of data I have.

I am to plot the age and weight on a scatter graph, which was no
problem, but the instructor wants us to designate which bears are male
and which are female, he suggested using X'S AND O'S.

My question is, How do I make specific symbols appear on the scatter
graph, it usually willl just show different colored plot points to
represent the data.
Click to expand...

Format Data Series/ Patterns/ Marker
 
Presumably, you already have a column with gender information. Suppose that
is column D. Also suppose your data start in row 2 (row 1 being a header).
Then, in some unused column, in row 2, enter the formula =IF(D2={male
identifier},"X","O")

Now, use an add-in (XY Chartlabeler from www.appspro.com or Chart Tools from
www.j-walk.com) to add this column as a chart label.

Further optional refinement: Hide the marker (double-click the series, then
select the Patterns tab, then set the Marker to 'none'.) Finally, center
the data labels (double-click the data labels, select the Alignment tab, and
adjust the Label Position).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top