4 variables scatter charting?

[ch33]

I need to make a scatter chart but have 4 variables. Can this be done in
Excel?

 

[David Biddulph]

If you have 3 dependent variables which are a function of 1 independent
variable, then it's easy, and it's the standard type of thing that the chart
wizard expects to deal with.
If you have 1 dependent variable which is a function of 3 dependent
variables, then it's not so easy.

You may need to explain further what you are trying to do.

 

[ch33]

Hi David:
Thank you so much for your help.
This will be very hard to explain, but.....
We have a graph that looks like this, and we need to plot out the high/low,
high/high, low/high....etc...:
abc efg
high low high low
fac 1 1 1
fac 2 1 1
fac 3 1 1
fac 4 1 1

 

[Tushar Mehta]

Given your data what do you expect the chart to look like?

Hi David:
Thank you so much for your help.
This will be very hard to explain, but.....
We have a graph that looks like this, and we need to plot out the high/low,
high/high, low/high....etc...:
abc efg
high low high low
fac 1 1 1
fac 2 1 1
fac 3 1 1
fac 4 1 1

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins