If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
4 variables scatter charting?
I need to make a scatter chart but have 4 variables. Can this be done in
Excel? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|