Gravity Simulator
http://www.orbitsimulator.com/cgi-bin/yabb/YaBB.pl
General >> Discussion >> Excel Question
http://www.orbitsimulator.com/cgi-bin/yabb/YaBB.pl?num=1163552678

Message started by Tony on 11/14/06 at 17:04:38

Title: Excel Question
Post by Tony on 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:







I want the 1... 10... 100... 1000 to be the graph's x-axis on a logarithmic scale.  How do I tell Excel to stop making it a data series?




145
1090
100180
1000360

Title: Re: Excel Question
Post by abyssoft on 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.

Title: Re: Excel Question
Post by Tony on 11/14/06 at 21:00:26

Sorry, I stated the problem, but I did not ask the question  :-[

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.

Title: Re: Excel Question
Post by 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.

Title: Re: Excel Question
Post by Tony on 11/14/06 at 21:37:51


Mal wrote:
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  >:(

Title: Re: Excel Question
Post by abyssoft on 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

Title: Re: Excel Question
Post by Tony on 11/14/06 at 22:24:51

That did the trick.  Thanks  ;D

Title: Re: Excel Question
Post by Tony on 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?

Title: Re: Excel Question
Post by abyssoft on 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

Gravity Simulator » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.