Creating scatter plots

[libertyforall]

How do I create a scatter plot. I've done line and bar graphs but
I'm not sure how to do a scatter plot. Also, how can I use data from
different tabs in the same excel file to create the graph. Will I need
to copy and paste all the data onto another tab?

 

[Andy Pope]

Hi,

For a scatter plot you need a set of x and y values. If you only have Y
values the x ones will automatically be a sequential series 1 to
number_of_Y_points.

Ideally you would have you X-values in a column with the Y-values in the
next column to the right.
You can make Excels job easier at guessing your data layout if you add a
series name to the top of the Y-values column.

Here is some info on charting from different sheets.
http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

Cheers
Andy

 

[Michael.Tarnowski]

How do I create a scatter plot. I've done line and bar graphs but
I'm not sure how to do a scatter plot. Also, how can I use data from
different tabs in the same excel file to create the graph. Will I need
to copy and paste all the data onto another tab?

Hi libertyforall,
beside the info Andy provided, have a look at
http://charts.jorgecamoes.com/10-x-10-tips-to-improve-your-excel-or-not-charts-the-scatter-plot/
Have fun
Michael