#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Scatter Graphs


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
------------------------------------------------------------------------
dcinc74's Profile: http://www.excelforum.com/member.php...o&userid=36738
View this thread: http://www.excelforum.com/showthread...hreadid=564606

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Scatter Graphs

Make your chart with two series, one for male and the other for female. Use
an unfilled circle as the marker for one and the 'X' symbol as the marker
for the other. Both marker styles are among the standard list of options
when you double click a series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"dcinc74" wrote in
message ...

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
------------------------------------------------------------------------
dcinc74's Profile:
http://www.excelforum.com/member.php...o&userid=36738
View this thread: http://www.excelforum.com/showthread...hreadid=564606



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel graphs won't update ejfu Charts and Charting in Excel 0 July 6th 06 11:18 PM
HYPERLINK GRAPHS Aurora Charts and Charting in Excel 0 April 10th 06 04:46 PM
Are there better GRAPHS within EXCEL or Add-on graphs? Deb Charts and Charting in Excel 1 February 1st 06 02:19 PM
Frequencies in Scatter Charts paulabrozek Charts and Charting in Excel 0 January 11th 06 09:31 PM
Scatter Chart Axis as text in C# Web appl Pavr1 Charts and Charting in Excel 1 March 31st 05 05:28 AM


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"