Thread: xy charts??

That would be a surface chart, and Excel has very limited capabilities for them.

I can visualize a simple surface (= 2 dimensional?) chart with independent variables on the x and y axes respectively and the dependent values graphed against each. As I said I've a feeling that x y charts do this, with or without dual axes, but I can't quite figure out how to do it. Trial and error?

I have a feeling that no x-y charts do this. You need need three independent axes.

If you wanted to chart (for example) the second hand values of a model of a car against the age and the mileage as displayed in various used car adverts, I can't see why Excel cannot do this (without resorting to 3 axes - I can't think in 3 dimensions!). There are only two independent variables to go on 2 independent axes. I thought this was what x y charts were designed to do.

Maybe. Draw one by hand, scan it and post it.

for xyz points you can try this
http://www.andypope.info/charts/3drotate.htm

Tks - the contents look really interesting even if I don't believe that for my simple purposes it's necessary to go to 3 dimensions let alone rotate them! I just need to get the hang of using standard xy charts properly and I suspect that somewhere within what you've sent will be the answer. Weekend's work ahead ..

Probably for you example of the car you need

X axis milage
Y axis age
Data label text is the car and cost

Use this free addin to link data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm

Great minds think alike. This is what I had in mind to progress to if and when I succeed in getting the 2-dimensional basics to work using what you sent previously (incl. how to lay out the raw data so that the chart picks it up properly)

for 5 pairs of value I would layout like this.

A2:A6 contains X values
B2:B6 contains Y values
B1 contains text to label series

Select A1:B6 and create a single series XY scatter.

Tks for realtime response! I'll have to experiment with this because in my case there is no direct correlation between the values in A2:A6 and B2:B6 as would be implied (both are "independent"). May be the xy graph function can accomodate this somehow. I have got my raw data set out in 2-D matrix form but haven't yet tried to "scatter" graph it.

You will need to alter the layout of your data.
Creating a 2 column list where each Row value is repeated for the unique Col value.

Sorry you've lost me there. I have attached an imaginary simple example of what I am trying to chart. May be you could show me what you mean using this.

This uses the index formula with a few IF tests to suppress empty matrix cells for outputting point or label.