4 variables scatter charting?
 

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

4 variables scatter charting?
 

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.
--
David Biddulph

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

4 variables scatter charting?
 

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




"David Biddulph" wrote:

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.
--
David Biddulph

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


.

4 variables scatter charting?
 

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

On Wed, 28 Oct 2009 12:01:01 -0700, ch33
wrote:

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




"David Biddulph" wrote:

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.
--
David Biddulph

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


.

Regards,

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