Video For Carly: Chemestry 2 X Y Scatter Diagrams 1 Chart

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 would like to make a Vector Diagram however I am facing serious difficulties with the Excel application and would appreciate some help. I managed to make a bar graph which is the closest I could come to a Vector Diagram.

I would like to know how to change those bars into thin lines as that will represent a Vector Diagram better. Please suggest on how I could do that. Requesting for urgent help and would appreciate any help

Thanks
Jaaj

The following is a video that demonstrate to you:
How to plot a chart with Microsoft Excel.
http://raymondlamsk.blogspot.com/200...w-to-plot.html

Cheers.

I have three sets of data in the attached spreadsheet. One X (Current Offering), one Y (Strategy), and then a third (Market Presence) that I don't know what to do with as it determines how big the plotted X,Y plot points are.

I essentially would like to replicate the attached jpg. Not sure how to combine the area chart (the radial circular lines) with the other data either. I don't have that data in the sample.xlsx though. I guess I would have to make it up to form the 4 areas to the chart.

I understand that in order to also display the labels for the data I need to do it through XY Chart Labeler
http://www.appspro.com/Utilities/ChartLabeler.htm

I've downloaded it, but haven't tried it yet, but I'm sure I can figure it out. There's several posts here on how to do it.

I'm in Excel 2007.

Hello,

I would like combine (overlay) a bubble chart with a connected point scatter chart.

I understand that, without VBA, this is not possible. However, I understand that, by using VBA, the markers of a scatter chart can be configured as circles with their size proportional to values in a specified column.

This pseudo-bubble chart can then easily be combined with a connected point scatter chart.

Unfortunately, I am a VBA newbie, and so I cannot yet write my own code. However, I can usually adapt other people's code to my specific environment without a problem.

My question is: does anyone have any VBA code to share that shows how to configure a scatter chart as the type of pseudo-bubble chart described above.

Cheers!

Jay

I have a line chart, dates on X axis and Numbers on Y and I layered in a scatter chart showing important events on certain dates. So the dates on the X axis are in months and years like Mar-01 and they are between 2000 and 2006. I only have 20 date points between those, but the chart shows every month between 2000 and 2006 but I dont have data for every month, just certain months. How can I fix this?

I'm trying to connect point on a (background graphic) circle with lines
(using Excel 2000). I have generated the X-cordinates for all ends of lines
in one column and, in each of the following columns, I have the Y-cordinates
for one line, two values next to each other; in the same rows as their
X-coordinates. All other cells are empty.

This works in smaller scale but when I have 250 lines, the X-values are
replaced with rising numbers, i.e. I get a line graphic.

Is there any way to make the scatter graphic work in large scale figures?

Thanks

Hello,

I would like to combine / overlay a bubble chart and scatter chart with straight connectors.

I understand that, without VBA, it is not possible to combine a bubble chart with a scatter chart.

Unfortunately, I am a VBA newbie, and so I cannot write my own code (though I can usually adapt code to my specific environment).

My question is: does anyone have VBA code to share that will convert a scatter chart series (x,y data in 2 columns) to a bubble-style chart (bubble radius in 3rd column)?

Cheers!

Jay

i have the data for open high low and close, as well as the moving average values. i want to put the ma lines on to the stock chart, how can i do it?

thank you

I have many sets of data for which the x-values run up from approx 60 to 100,
and back down to 60ish. Each set of data consists of 200 points. I can
happily display each set individually on a scatter chart, with the categories
from, 60 (at point i=1)to 100 (i=100) to 60 (i=200). My probably occurs when
I want to display two sets of data on the same graph. For each set, the
x-values vary, for example another set could run from 65 to 95 then back to
65, but it still contains 200 points. Excel will only allow one set of values
on the category axis, so only one data set will be correctly represented by
the x-values. Using a scatter graph uses numerical x-values rather than
categories, so my x-values only go from 60ish to 100ish, which is not what i
want.

Is there any way to use numerical values on a line chart, and have each data
set represented correctly against the x-axis? Or similary can I create a
scatter graph with x-values running from 60 to 100 to 60?

Any help greatly appreciated.