Excel Scatter Plot

  • Thread starter Thread starter adamuk
  • Start date Start date
A

adamuk

Hello! I'm very new to using Excel, and having problems creating a
scatter plot. I have tried using the wizard/chart button on excel, but
must be doing something wrong as it's not displaying the data
correctly. I'm hoping somebody will help me, please. I'm pulling my
hair out, as i cannot do it!!

Basically, i have been given the following fields of data -

Territory 1 2 3 4 5 6
7 8 9 10
Showings 3 1 4 0 2 4 0
3 1 2
Sales 2.6 1.2 3 1 2 3.6
0.5 3.2 1.8 2.5

I have been told to 'Construct a scatter plot of the data'.

Could somebody please give a few minutes to try and find out how to do
it?
I have attached my (feeble!) attempt at it. I'm hoping i have done it
correctly. If not, cound somebody please tell me what i have done
wrong?

I don't think it's imperative to plot the territory. I think 'showings'
and 'sales' compare better. But if i can somehow include territory then
it would be better.


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4528 |
+-------------------------------------------------------------------+
 
Adam:

I have looked at your scatter plot. A few points:

1. You have created a scatter chart.

2. Data Table - you have set your data up horizontally, data going from left
to right.
It is usually preferable to arrange your data in a vertical format.


3. You can easily transpose your data by selecting - copying it, select a
copy to cell , then use Edit > Paste special > Transpose . This will arrange
your data vertically.

4. Chart Aesthetics - there are several aesthetic improvement that you can
make, remove legend, remove gray background color, etc.

I have a page on Effective Charting that gives a series of tips on how to
improve on Excel's default chart appearance.

http://processtrends.com/pg_chart_tips.htm#Effective_Charting

....Kelly

(e-mail address removed)
 
Your data looks straightforward enough. Just to make sure: for best results,
the data should be in a contiguous range, no blank rows or columns. It's
better in columns, but it's okay in rows. For an XY chart, all data should
be numerical, which yours seems to be. For chart types other than XY, delete
the label in the top left cell, to help Excel determine the categories and
series names.

If the data is appropriately arranged, select the entire range (including
categories and series names) and run the chart wizard. Choose the chart type
in step 1, and in step 2 check that the data range was correctly
interpreted.

If this doesn't work, describe in words what's wrong. Most people will not
open a file. Many because of viruses, but me because of the time and effort
it takes. Avoid the easy out of clicking the Attach button.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
 
Back
Top