4 variables scatter charting?

  • Thread starter Thread starter ch33
  • Start date Start date
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.
 
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
 
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
 
Back
Top