PC Review


Reply
Thread Tools Rate Thread

Can you make a scatter graft - if so how?

 
 
=?Utf-8?B?TGVhbm5l?=
Guest
Posts: n/a
 
      3rd Aug 2005
I am wanting to make a scatter graft or dot graft but do not know how
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      3rd Aug 2005
Put your X values into one column, and your Y values into the next
column, and if you want to name the series of points, put the label into
the cell just above the first Y value. Select the data, and run the
chart wizard (the little chart icon on the standard toolbar, or go to
Insert menu > Chart). In step one, choose an XY Scatter type, then
continue through the wizard.

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


Leanne wrote:

> I am wanting to make a scatter graft or dot graft but do not know how

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How does one make a scatter plot where x or y data are blank? djmac23 Microsoft Excel Charting 1 10th Jun 2009 07:02 AM
how do i insert the best fit line into my graft please? pidge Microsoft Excel Misc 2 2nd Mar 2009 01:58 AM
Re: Can we make XY Scatter Chart using Pivot Tables Andy Pope Microsoft Excel Programming 0 4th Jan 2007 04:26 PM
make all markers the same in a scatter plot =?Utf-8?B?WFhCRVhY?= Microsoft Excel Charting 1 22nd Feb 2006 11:00 PM
I need to make a scatter diagram. =?Utf-8?B?V2F5bmUgQW5kcmV3cw==?= Microsoft Word Document Management 2 25th Oct 2005 06:50 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:57 PM.