04/18/19 at 14:08:56 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.

 Pages: 1
 Excel Question (Read 5459 times)
Tony

Posts: 1060
Gender:
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:

 1 45 10 90 100 180 1000 360

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 IP Logged
 Tony YaBB Administrator Posts: 1060 Gender: Re: Excel Question Reply #2 - 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. Back to top IP Logged
 EDG Ultimate Member oh, crumbs!!! Posts: 611 Gender: 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)   IP Logged
 Tony YaBB Administrator Posts: 1060 Gender: 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 Back to top 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 IP Logged
 Tony YaBB Administrator Posts: 1060 Gender: Re: Excel Question Reply #6 - 11/14/06 at 22:24:51   That did the trick.  Thanks Back to top IP Logged
 Tony YaBB Administrator Posts: 1060 Gender: 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 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 IP Logged
 Pages: 1
 Forum Jump: ----------------------------- General -----------------------------=> Discussion