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?

 1 45 10 90 100 180 1000 360

 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 plotCreate chartselect XY scatterChoose scatter with data point connected by smooth linesClick NextClick on the series tabset X-Values to the 2nd columnset Y-Values to the 1st columnClick Next x 2Choose as new sheetRight Click Y axis Select Format AxisClick on the Scale Tab Check Use Log scaleClick OKPresto 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