# 4 variables scatter charting?

ch33
Guest
Posts: n/a

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

David Biddulph
Guest
Posts: n/a

 28th Oct 2009
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?

ch33
Guest
Posts: n/a

 28th Oct 2009
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?

>
>
> .
>

Tushar Mehta
Guest
Posts: n/a

 29th Oct 2009
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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post edeaston Microsoft Powerpoint 3 26th Sep 2008 03:10 PM jgarza@soppchevrolet.com Microsoft Excel Charting 1 8th Dec 2005 01:58 PM jgarza@soppchevrolet.com Microsoft Excel Charting 1 8th Dec 2005 01:58 PM =?Utf-8?B?SmFuZQ==?= Microsoft Excel Charting 1 22nd Jun 2005 03:55 PM Bonny Windows XP Setup 0 11th Jul 2003 06:01 AM

Features