| General Chat... This forum is for general chit-chat, banter, exchange of information, etc. Pretty much everything goes... within reason! |
 |
23rd February 2011, 22:17
|
#1
|
|
Saxperience Addict
Join Date: Jan 2008
Location: west london
Posts: 13,810
|
Any excel boffins here?
with making a graph, how do you swap the axis over? i want one set of values to be across the bottom but cant see how to do it 
|
|
|
|
23rd February 2011, 22:19
|
#2
|
|
Saxperience Forum Bum
Join Date: May 2007
Posts: 4,857
|
LOL what software are you using?
|
|
|
|
|
23rd February 2011, 22:20
|
#3
|
|
Saxperience Addict
Join Date: Jan 2008
Location: west london
Posts: 13,810
|
microsoft excel, 2003 version i think  cant stand the new version
|
|
|
|
|
23rd February 2011, 22:21
|
#4
|
|
Saxperience Hardcore!
Join Date: Nov 2009
Location: Northern Monkey
Posts: 17,064
Car(s): Work van che.
|
Copied from the Internet....
1)Right click in the Chart Area (the white border on the chart)
2)Select he Source Data item from the popup menu
3)Open the Series tab
4)Note the item X-value ....Sheet1$A$10...<red thing>
Click the red thing, select the read x-values with mouse, click the red
thing again
|
|
|
|
|
23rd February 2011, 22:24
|
#5
|
|
Saxperience Forum Bum
Join Date: May 2007
Posts: 4,857
|
Not used that versions or not for a long time but if what Moke said does not work you can just swap the data round on your database and make the graph as you where before.
|
|
|
|
|
23rd February 2011, 22:26
|
#6
|
|
Saxperience Addict
Join Date: Jan 2008
Location: west london
Posts: 13,810
|
cheers guys! it worked
|
|
|
|
|
23rd February 2011, 22:28
|
#7
|
|
Saxperience Forum Bum
Join Date: Sep 2008
Location: Bangor N.Wales
Posts: 3,085
Car(s): B5.5 Passat 20V Turbo
|
also you can use ALT+F4
__________________
B5.5 Passat 20V Turbo - the Motorway Missile
|
|
|
|
|
23rd February 2011, 22:28
|
#8
|
|
Saxperience Hardcore!
Join Date: Nov 2009
Location: Northern Monkey
Posts: 17,064
Car(s): Work van che.
|
Ah Google, what would the world do without you? 
|
|
|
|
|
23rd February 2011, 22:41
|
#9
|
|
Saxperience Forum Bum
Join Date: Apr 2010
Location: Telford
Posts: 4,501
Car(s): Black corsa c SXI.
|
Quote:
Originally Posted by M1VT
also you can use ALT+F4
|
__________________
Quote:
Originally Posted by L20VTS
I actually love the Wolvo accent.
|
Facepalm 
|
|
|
|
|
23rd February 2011, 22:42
|
#10
|
|
Saxperience Forum Bum
Join Date: Apr 2010
Location: Telford
Posts: 4,501
Car(s): Black corsa c SXI.
|
Quote:
Originally Posted by Moke
Ah Google, what would the world do without you? |
bing 
__________________
Quote:
Originally Posted by L20VTS
I actually love the Wolvo accent.
|
Facepalm
|
|
|
|
|
23rd February 2011, 22:43
|
#11
|
|
Saxperience Hardcore!
Join Date: Nov 2009
Location: Northern Monkey
Posts: 17,064
Car(s): Work van che.
|
Quote:
Originally Posted by VTHall
bing |
Feck off. Bing is as useful as Steven Hawkins' legs.
|
|
|
|
|
23rd February 2011, 23:10
|
#12
|
|
Regular Poster
Join Date: Apr 2010
Location: Melksham
Posts: 252
Car(s): Citroen Saxo VTR Silver
|
Quote:
Originally Posted by Moke
Feck off. Bing is as useful as Steven Hawkins' legs.
|
 Great
Look in sig 
__________________
Quote:
Originally Posted by Moke
Feck off. Bing is as useful as Steven Hawkins' legs.
|
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT. The time now is 23:02.
|
Linear Mode
