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

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" <(E-Mail Removed)> wrote in message
news:AB7B8788-78E0-45C4-A29F-(E-Mail Removed)...
>I need to make a scatter chart but have 4 variables. Can this be done in
> Excel?

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" <(E-Mail Removed)> wrote in message
> news:AB7B8788-78E0-45C4-A29F-(E-Mail Removed)...
> >I need to make a scatter chart but have 4 variables. Can this be done in
> > Excel?
>
>
> .
>

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

On Wed, 28 Oct 2009 12:01:01 -0700, ch33
<(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
>> news:AB7B8788-78E0-45C4-A29F-(E-Mail Removed)...
>> >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