|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
04-23-2007, 03:56 PM
|
#1 |
|
Banned
Join Date: Jul 2004
Posts: 106
|
excel graph question
I got 2 data set and need to graph each data set on same graph. I got office 07 and can't figure out how to create that. Why did mnicrosoft have change great graph wizzard that was included in 03
 TIA |
|
|
|
04-23-2007, 04:05 PM
|
#2 |
|
Premium Member
Join Date: Jun 1999
Posts: 9,231
|
AFAIK the graph wizard in O2k7 does everything 2k3 did and more.
You can still plot multiple series on the same graph .. right click on the chart and go to Source Data .. Series tab .. you should be able to add on as many data series as you like. |
|
|
|
|
04-23-2007, 04:12 PM
|
#3 |
|
Banned
Join Date: Jul 2004
Posts: 106
|
here is the data i am talking about, for some reason wheni tried i wasn't able to do it. If someone could do it it would be great. I great it should work easily but for some i can't do it
edit:trying to make it scatter graph Last edited by formerjudge; 04-23-2007 at 04:17 PM. |
|
|
|
|
04-23-2007, 08:08 PM
|
#4 |
|
Computing Professor
Staff
Premium Member
Join Date: Jun 2001
Posts: 11,718
|
I use Office Calc., set to display/use the Excel format by default, but I can't get into your file at all.
Sorry.
__________________
Asus M4A77D, 64 X2 6000+, 4 GB Corsair DDR2 800 ram, Radeon 5770. |
|
|
|
|
04-23-2007, 08:16 PM
|
#5 |
|
Banned
Join Date: Jul 2004
Posts: 106
|
I resaved it in earlier excel format, sorry about that. Can you try it one more time. TIA
|
|
|
|
|
04-23-2007, 08:52 PM
|
#6 |
|
Computing Professor
Staff
Premium Member
Join Date: Jun 2001
Posts: 11,718
|
OK, it's opened just fine and I'll take a look at it for you.
|
|
|
|
|
04-23-2007, 09:40 PM
|
#7 |
|
Computing Professor
Staff
Premium Member
Join Date: Jun 2001
Posts: 11,718
|
I tried to create a graph, using the wizard and your spread sheet data, but simplifying it.
Open Calc. promptly crashed. |
|
|
|
|
04-23-2007, 10:06 PM
|
#8 | |
|
Banned
Join Date: Jul 2004
Posts: 106
|
Quote:
|
|
|
|
|
|
04-24-2007, 01:01 AM
|
#9 |
|
Ceiling cat is watching!
Join Date: Feb 2006
Location: Iowa
Posts: 1,283
|
To make a scatter plot you need X and Y. What is X and what is Y? You'll need to organize your X and Y into just 2 columns and the graph should be excedingly easy to create.
__________________
~Matt CCNA |
|
|
|
|
04-24-2007, 06:22 AM
|
#10 |
|
Premium Member
Join Date: Jun 1999
Posts: 9,231
|
Are these the kind of plots you're looking for?
|
|
|
|
|
04-24-2007, 08:50 AM
|
#11 | |
|
Banned
Join Date: Jul 2004
Posts: 106
|
Quote:
|
|
|
|
|
|
04-24-2007, 11:34 AM
|
#12 |
|
Premium Member
Join Date: Jun 1999
Posts: 9,231
|
The chart "wizard" as it were in O2k7 does everything versions before did without those annoying NEXT buttons on the old versions. All you need to do is first select the data A1:M18 and then press the CTRL button and select another box A21:M38. Create a chart by going to Insert>Chart (scatter). It should work the same for previous versions of excel as well.
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Microsoft Excel Coding Question | Vigilante_26 | Web Design / Development | 2 | 01-27-2003 08:02 PM |
| Excel question | fatboyjim | Software Discussion & Support | 2 | 01-05-2003 05:33 AM |
| Excel 97 question (weird issue) | merlin63 | Software Discussion & Support | 1 | 11-20-2002 12:49 AM |
| Question about Excel | andersson1974 | Web Design / Development | 5 | 11-15-2002 07:31 PM |
| Excel prob: Compile error in hidden module | calamospiza | Software Discussion & Support | 2 | 09-24-2002 04:12 AM |
Linear Mode
