Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

3D Scatter plot in Excel

How do I make a 3D scatter plot in Excel? Ideally I will be able to define
the viewing angle of the 3D graph. Alternaviely, are there plug-ins that can
fix this that are not too expensive? Alternatively, which other tools are
available that are not expensive and are easy to use?


Post your answer or comment

comments powered by Disqus
Hi,

I'm trying to create a scatter plot chart in excel 2007 with a label
on each point. But I can't seem to do this without creating 50
different series. I have three columns (x-axis, y-axis, and labels).
Is there a anyway to plot points and then at a separate label?

I need to create a "true" scatter graph in excel.
Just like school were you plotted variable x against variable y.
That way, you just get a feel for the trend, if any.

I need to do this in excel as I have 200 variables to plot, and they come from excel in the first place.
Scatter diagram would be perfect for this, as it will show outliers.

I thought that I would do a test in excel with car data, as we all live & breathe cars.
Basically 0-100 mph times should *generally* be related (correlated ??) to bhp per tonne.
Generally ??
I would expect a scatter diagram to show this quite well.
In fact my manual plot of 12 cars does this very well - except the CCX.
(the CCX is slow in relation to it's power)

However, on the below data, excel fails to produce what I want.
I want Excel to produce 'the school plot' as mentioned above.
Any ideas ?

Make 0-100 mph bhp / tonne
Ultima 5.5 666
Enzo 6.7 484
CCX 7.7 694
GT3 996 10.3 271
RS 993 11.2 240
M3 E36 12.8 215
330ci 16.6 154
M3 E30 17.8 178
Elise si 18.5 164
x Type 3L 19.8 151
MR2 21.2 141
Puma R 23.2 132

What I dont want, (and what excel produces) is a 'scattergraph' but with both values plotted - which is meaningless.

Hello,

I need to create a scatter plot in Excel 2007 and I am clueless.

I have two columns, one called REASON, the other called LENGTH OF
TENURE IN DAYS.

I have selected both columns and attempted to insert a Scatter chart,
but to no avail. Can you please help?

Jeff

I am a fairly experience Excel XP and 2003 user and I have a few questions:

Why is it when I work with scatter plots in Excel 2007 my dual Xeon CPU
computer with 4 GB RAM slows to a crawl? Is this a feature? It's never done
that with Excel XP, Excel 2003, or any other application.

How does one add chart and axis labels to a scatter plot? Not that I need
them, all my end users prefer scatter plots with no axis labels. That way
the charts can be interpreted any way they please. Yet another feature?

Given a scatter plot with a singe series of 4 data points, how does one add
a 2nd degree polynomial trend line to the data? And why is it when I try to
do that and display the polynomial equation on the chart a linear equation is
displayed? Is Excel 2007 dropping the 2nd degree factor from the trend line
label or is Excel 2007 refusing to do a quadratic fit because it thinks I do
not have enough data points? Another feature, right?

I have a table the I need to graph as a scatter plot in excell. I would would like the the points below to be graphed as (X,Y) with the issue being each individual plot. I am not sure how to do this? I would like it so each plot point to be a different color so the legend has a differenc color and the name of each plot pont. I am having trouble figuring this out. I am using 2003 version of excell can someone help me? Thanks

Plot Point Y X
Issue impact chances of continuing
NPI 4 3
Population Growth 6 5
Elderly Population 8 9
Manufacturing Jobs 5 7
Work Related Injuries 6 5
Downtown Business 8 7
CHIP Reauthorization 8 8
Electronic Medical Records 7 9
Managed Care Programs web 4 4
Nursing Shortage 5 7

How do I make Excel use the minimum/maximum axis values selected in my data so I do not have to go back and reformat the axis?
How can I make Excel accept a time value formatted as 9:00:00 in the Axis Dialog box so I don’t have to determine the decimal time value?

I select time values in column B from 9:00:00 to 11:00:00 and then select corresponding data in column D. Click Insert=>Scatter. I want the chart category axis to begin at the time 9:00:00, the first data point that was in my column B selection, but Excel 2007 uses displays the scatter chart category minimum value of 00:00:00. I then click right click category axis and select format axis. In the AXIS Dialog box I Fixed to the right of the word Minimum. I know the time I want to enter but Excel 2007 will not accept the time format as 9:00:00 so I have to go to the spreadsheet with the data and select the cell with the time 9:00:00 and right click and select Format Cells then select General under Category so I can read (memorize) the time in Excel number format.

I have a scatter plot in excel 2003 that appears linear when both axes are plotted using the logarithmic scale option.

I need to determine the slope of this line as if the scales were linear (even though they are actually logarithmic).

Please help, thanks!

When I hover over a line on a scatter chart in Excel 2007, I see incorrect inormation about the nearest data point.

When I hover over a line on a scatter chart in Excel 2007, I see incorrect inormation about the nearest data point.

I believe that this only occurs when I set the Min and Max scales for the chart.

If I save the workbook to 2003 format and open in Excel 2003, the data point information is correct.

Hi

I have to create a chart XY Scatter plot in excel. I have to differentiate the data points color based on the another column "category". Now I can change the data points color manually. Since the number of points is huge, is it possible to color the data points based on a column?

Thanks,
Iswaria

How can I construct a polar plot in excel 2007, I would like to plot the following:

Gain (modulus) θ° (argument) 1.688 -35.94 1.43 -86.4 1.125 -130.6 0.95 -156.76 0.747 -191.86 0.607 -223.24

I'm trying to plot house prices and house types on a scatter plot in
Excel. To aid analysis by the reader I want to include median and
interquartile lines for each category like 'this example'
(http://img.photobucket.com/albums/v4...ewis/chart.gif).

I can plot plain scatter plots no problem in Excel 2003 but I don't
know where to begin for adding these extra features. Can anyone help
me?

ninja-lewis

--
ninja-lewis
------------------------------------------------------------------------
ninja-lewis's Profile: http://www.excelforum.com/member.php...o&userid=34016
View this thread: http://www.excelforum.com/showthread...hreadid=537806

I wanted to make a 3-dimensional plot in Excel and discovered that I cannot
do this. All you can do is make 3-D charts over two dimensions, you cannot
make 3-D plots over three dimensions. There's the surface plot, but that
only plots x and y along with the series. I want to plot true x, y, and z.
HELP!

John W. Mordosky

i am trying to create a scatter plot in excel with one set of x vaules, and 2 sets of y values ( both sets of y value data uses the same variable). essentially, how can i get two scatter plots on one graph ? is it possible ? do you guys know what i mean ?

thanks,

Malcolm347

I have a scatter plot in excel 2003 that appears linear when both axes are plotted using the logarithmic scale option.

I need to determine the slope of this line as if the scales were linear (even though they are actually logarithmic).

Please help, thanks!

I am trying to plot an Archimedes spiral with the radar plot in Excel and can
only obtain one revolution. I need multiple revolutions and would also like
to have multiple arms in the spiral.

I want to know a simple way to make a box and whiskers plot in Excel 2003?
Is there a function?

Hello. I was trying to use vba to generate some xy scatter plots. It seems
like a simple task, but I haven't been able to find much on it. Anyways, I
have one column of data which I want to be the x-values, and another column
of y-values. I want to set the y-axis to a logarithmic scale, and I want to
be able to specify the maximum and minimum x and y values. Any help would be
greatly appreciated.

I need help adding a treadline to an xy scatter plot in excel?

Hi, guys

I tried to make a scatter plot in Excel. The issue is that there are
repeated data points.
For example,
(x,y) style (1,3.4), (2,5.5), (2,5.5), (3, 9.9), (3,9.9), (4,23.0)...

Can I add a related frequency number around the corresponding data
point?

Thank you for your help!
Ming

I'm trying to plot house prices and house types on a scatter plot in Excel. To aid analysis by the reader I want to include median and interquartile lines for each category like this example.

I can plot plain scatter plots no problem in Excel 2003 but I don't know where to begin for adding these extra features. Can anyone help me?

ninja-lewis

Hi there,
Just wondering if there's any way you can graph a quantile quantile plot in
Excel?
Any help is appreciated

Hi,

I have an xy scatter plotted in excel. For a certain y value, I want the corresponding x value based on the plot. How to show that in the chart? Please view the screenshot attached for better undestanding.

I am trying to create a box plot in excel. My book says to go to tools and
Data Analysis Plus. I have already added data analysis, but I have no Data
analysis plus. Can anyone help?

Does anyone know of any free software out there that will perform 3D
XYZ plotting based on data in Excel? I have seen previous posts asking
the same thing that were dated around 2002. I have Excel 2003, but I
still don't believe that capability exists. If there are free packages
that would do it, without spending a lot of $ on a package for just
this purpose, that would be great.

Thanks
Scotty81


No luck finding an answer? You could always try Google.