New Posts  All Forums:Forum Nav:

Exel Question

post #1 of 8
Thread Starter 
Not sure if this is the right place to post this question but..how can I graph the following because I'm getting the Y-axis on the X-axis and I want it the other way around.
4.3492.3461.75670
4.8392.6472.06180
5.6053.0912.47290
6.2163.3272.672100
7.0323.6652.951110

are the number I want to graph
The Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 780i 3-way sli, extreme core support 8800 GTX (X2) 4GB RAM DDR2 
Hard DriveOSMonitorPower
500GB Windows Vista 32 bit CRT 21" 800W SLI support 
CaseMouse
420W case Logitech 
  hide details  
Reply
The Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 780i 3-way sli, extreme core support 8800 GTX (X2) 4GB RAM DDR2 
Hard DriveOSMonitorPower
500GB Windows Vista 32 bit CRT 21" 800W SLI support 
CaseMouse
420W case Logitech 
  hide details  
Reply
post #2 of 8
what type of graph?
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel i5 2500K gigabyte z68x-ud3h-b3 2 x Sapphire 6950 (unlocked to 6970) 12Gb Gskill Ripjaws 
Hard DriveOSCase
Intel X25 SSD, 6TB WD Greens Windows 7 Ultimate x64 Soldam Windy Alcadia FX2000R SOJ 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel i5 2500K gigabyte z68x-ud3h-b3 2 x Sapphire 6950 (unlocked to 6970) 12Gb Gskill Ripjaws 
Hard DriveOSCase
Intel X25 SSD, 6TB WD Greens Windows 7 Ultimate x64 Soldam Windy Alcadia FX2000R SOJ 
  hide details  
Reply
post #3 of 8
Go into graph.
Select XY Scatter.
Select your Data Range.
Series in row (or columns).
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
post #4 of 8
Thread Starter 
here is the picture I want the axis the other way around.

http://img183.imageshack.us/img183/7739/excel1ku1.jpg
The Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 780i 3-way sli, extreme core support 8800 GTX (X2) 4GB RAM DDR2 
Hard DriveOSMonitorPower
500GB Windows Vista 32 bit CRT 21" 800W SLI support 
CaseMouse
420W case Logitech 
  hide details  
Reply
The Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 780i 3-way sli, extreme core support 8800 GTX (X2) 4GB RAM DDR2 
Hard DriveOSMonitorPower
500GB Windows Vista 32 bit CRT 21" 800W SLI support 
CaseMouse
420W case Logitech 
  hide details  
Reply
post #5 of 8
Quote:
Originally Posted by thecountzz View Post
here is the picture I want the axis the other way around.

http://img183.imageshack.us/img183/7739/excel1ku1.jpg
Select the series by row....

OR cut and paste the data with transpose (under Paste Special).
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
post #6 of 8
Thread Starter 
Can you post a picture of how to use either one of them so I can get a more clear picture
The Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 780i 3-way sli, extreme core support 8800 GTX (X2) 4GB RAM DDR2 
Hard DriveOSMonitorPower
500GB Windows Vista 32 bit CRT 21" 800W SLI support 
CaseMouse
420W case Logitech 
  hide details  
Reply
The Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 780i 3-way sli, extreme core support 8800 GTX (X2) 4GB RAM DDR2 
Hard DriveOSMonitorPower
500GB Windows Vista 32 bit CRT 21" 800W SLI support 
CaseMouse
420W case Logitech 
  hide details  
Reply
post #7 of 8
Quote:
Originally Posted by thecountzz View Post
Can you post a picture of how to use either one of them so I can get a more clear picture
Method #1: move your data
Copy your data.
Right click.
Select "Paste Special".
Select "Transpose".
Hit OK.
Do your graph again.


Method #2: define your series
Highlight your data.
Select the chart wizard.
Select XY Scatter.
Select "Series in Column".
Create graph.
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
post #8 of 8
Thread Starter 
thanks for the help
The Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 780i 3-way sli, extreme core support 8800 GTX (X2) 4GB RAM DDR2 
Hard DriveOSMonitorPower
500GB Windows Vista 32 bit CRT 21" 800W SLI support 
CaseMouse
420W case Logitech 
  hide details  
Reply
The Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 780i 3-way sli, extreme core support 8800 GTX (X2) 4GB RAM DDR2 
Hard DriveOSMonitorPower
500GB Windows Vista 32 bit CRT 21" 800W SLI support 
CaseMouse
420W case Logitech 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software