EXCEL Scatter Graphs

[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

 

[David Biddulph]

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.

Format Data Series/ Patterns/ Marker

 

[Tushar Mehta]

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