Welcome, Guest. Please Login.
Gravity Simulator
11/18/17 at 04:20:25
News: Registration for new users has been disabled to discourage spam. If you would like to join the forum please send me an email with your desired screen name to tony at gravitysimulator dot com.
Home Help Search Login


Pages: 1
Send Topic Print
Excel Question (Read 3482 times)
Tony
YaBB Administrator
*****




Posts: 1049
Gender: male
Excel Question
11/14/06 at 17:04:38
 
If I have 2 columns of data, sometimes Excel uses the first column as the x axis of the graph, and sometimes it treats it as a data series.  For example, I'm trying to plot a log graph.  I have 2 columns of numbers:
 
145
1090
100180
1000360
Back to top
 
 
Email View Profile WWW   IP Logged
abyssoft
YaBB Administrator
*****


I love YaBB 1G -
SP1!

Posts: 302
Re: Excel Question
Reply #1 - 11/14/06 at 18:28:46
 
Not quite sure what the question is Tony?  Or I'd Give you an Answer, as I'm a bit of a spreadsheet-aholic.
Back to top
 
 
View Profile WWW   IP Logged
Tony
YaBB Administrator
*****




Posts: 1049
Gender: male
Re: Excel Question
Reply #2 - 11/14/06 at 21:00:26
 
Sorry, I stated the problem, but I did not ask the question  embarrassed
 
Excel want the y-axis to be the numbers of the columns.  So instead of having a log scale ranging from 0 to 1000, in the following example, it goes linearly from 0 to 4, with 2 data series:  1-1000 and 45-360.  I want one data series, 45-360, with a logrithmic y-axis spanning from 0 to 1000.
 
My graph should plot the points (45,1), (90,10), (180, 100), (360,1000).  I believe it will form a straight line.
 
I've since figured out that I can choose log scale in custom chart type, but it still picks the extremes for me.
Back to top
 
 
Email View Profile WWW   IP Logged
EDG
Ultimate Member
*****


oh, crumbs!!!

Posts: 611
Gender: male
Re: Excel Question
Reply #3 - 11/14/06 at 21:26:40
 
Are you plotting this using the Line Graph, or the XY (Scatter) graph? It sounds like you should be plotting on the latter.
Back to top
 
 

(formerly known as Mal)
View Profile WWW   IP Logged
Tony
YaBB Administrator
*****




Posts: 1049
Gender: male
Re: Excel Question
Reply #4 - 11/14/06 at 21:37:51
 
Quote from Mal   on 11/14/06 at 21:26:40:
Are you plotting this using the Line Graph, or the XY (Scatter) graph? It sounds like you should be plotting on the latter.

 
I've tried both  Angry
Back to top
 
 
Email View Profile WWW   IP Logged
abyssoft
YaBB Administrator
*****


I love YaBB 1G -
SP1!

Posts: 302
Re: Excel Question
Reply #5 - 11/14/06 at 21:56:15
 
Ok I played with it and got an answer for you.
Select Columns to plot
Create chart
select XY scatter
Choose scatter with data point connected by smooth lines
Click Next
Click on the series tab
set X-Values to the 2nd column
set Y-Values to the 1st column
Click Next x 2
Choose as new sheet
Right Click Y axis  
Select Format Axis
Click on the Scale Tab  
Check Use Log scale
Click OK
 
Presto it's finished
Back to top
 
 
View Profile WWW   IP Logged
Tony
YaBB Administrator
*****




Posts: 1049
Gender: male
Re: Excel Question
Reply #6 - 11/14/06 at 22:24:51
 
That did the trick.  Thanks  Grin
Back to top
 
 
Email View Profile WWW   IP Logged
Tony
YaBB Administrator
*****




Posts: 1049
Gender: male
Re: Excel Question
Reply #7 - 11/15/06 at 10:34:18
 
Another Excel question:
 
I like to play with the colors of the graphs rather than use Excel defaults.  But it takes a while to change the colors of the background, plot area, legend, etc.  Is there any way to save a template of color schemes?
Back to top
 
 
Email View Profile WWW   IP Logged
abyssoft
YaBB Administrator
*****


I love YaBB 1G -
SP1!

Posts: 302
Re: Excel Question
Reply #8 - 11/15/06 at 14:27:58
 
I believe custom graph templates are available in office 2005 and later. but I have no Idea how to access them as I'm still content with my office 2K
Back to top
 
 
View Profile WWW   IP Logged
Pages: 1
Send Topic Print