How should the data be entered in a logarithmic chart. I want the log data entries to be on the left and the other data to be displyed on the bottom. My chart will give a logarithmic resistance vs RH. I have tried to list the data by columns left to right first the resistance then thRH for 4 different series. It just doesn,t look right and I cannot change anything easily. Are there any sources for making charts in excel ,especialy Logarithmic ones? Thanks for any help? Hi Ed, In A1:A10 enter your resistance values (the x-values) In B2:B10 enter the RH (meaning?) values (the y-values) Sel...

Trendline equation constants. A trendline has been drawn on a chart and an acceptable equation has been obtained. The constants in this equation must be used in other formulas. How are these constants written into cells that can be used in formulas? This is needed when the data producing a trendline, can change and thus have an effect through the page. You can get this using the worksheet array function LINEST (see the help files), or by parsing the formula using Dave Braden's code, posted here: http://groups-beta.google.com/group/microsoft.public.excel.misc/browse_frm/thread/edb6...

I have 3 sets of data for different conditions. When charted, 2 sets have the option to "add trendline", but the third set (with more "ups and downs' in the data) does not have the option available. There are no empty cells in the source data nor are there multiple series on the chart. Any ideas why I don't have the ability to add a trendline on this set of data. At first, I thought it was perhaps because there isn't a high enough order in the polynomial fit, but paring down the data so there is only one peak did not help (that is, add trendline was still not ...

how do i plot a graph with the x axis in a semi log format using excel 2007? i no how to do it in the previous version of excel but cant find out how to do it in this version...thanks for any help Right click on the axis to be treated (the numbers will then have a box around them) Select Format Axis from the popup menu to open the format dialog On the Axis Options tab (look to the left to see the tab names), about half-way down, locate Logarithmic Scale and check the box Note that we can now use logs to various bases not just 10; I like to use base 2 in many circumstances best wishes --...

I have a chart I am trying to plot data from 0ng to 1.9mg and a logarithmic scale works beautifully except that I have an important value at a 0ng (the start of my curve). Is there anyway to make the 0 value show up in a logarithmic scale? Thanks, -E No. Zero on a log scale would be at minus infinity. You could change the value from zero to something very small (10^-n g), but how small you make it will affect where it appears on the log scale; that's how logarithms work. -- David Biddulph "E" <E@discussions.microsoft.com> wrote in message news:D416CA9D-CD05-41...

I have created a bar graph from a pivot table that shows the number of events that occurred on specific dates, grouped by month. When I right click the series to add a trendline the 'Add Trendline' option is grayed out. Why is this? Excel 2003. The original data is in the form of a single column of data, each row contains only a single date. All dates are valid and there are no nulls in the data set. Pivot charts are not nearly as useful as regular charts, despite their pivot behavior. I almost always make a regular chart from pivot tables. Here's how: Select a blan...

Excel provides EXP as the inverse of LN. Does it provide yhe inverse of LOG10 or do I have to manufacture my own? Yes, I'm afraid you'll have to manufacture your own. It's eally difficult <g> =10^A1 On Mon, 7 Mar 2005 19:35:06 -0800, "KG" <KG@discussions.microsoft.com> wrote: >Excel provides EXP as the inverse of LN. Does it provide yhe inverse of LOG10 >or do I have to manufacture my own? or just stick to natural logarithms. heehee "Myrna Larson" wrote: > Yes, I'm afraid you'll have to manufacture your own. It's e...

An Excel logarithmic trendline attached to a data series has the following: Equation Y=533371Ln(x)-3E+06. R2 = 0.9533 (a good fit for the data) Final value (where the trendline crosses the right-hand (secondary) axis) = ~420,000 (the value Iām ultimately seeking) I have created a new series with this equation to create the same curve with the following: Formula: =533371LN(1)-3000000 Final value produced with this formula: 195,673 (obviously not close to the Excel value ~420,000) Changing the ā-3E+06ā value to 2,600,000 produces 414,873 ā...

Thanks both, it is good to know that I wasn't missing some obvious button on an obscure menu somewhere and that Excel really isn't able to do this task on its own. The question is why Microsoft haven't done anything about it because it has been a bone of contention for a number of years and it is a reason for many in the engineering and scientific community to write the programme off as not a serious charting tool. That's a shame because to my mind Excel is the strongest member of the Office family. Does Microsoft plan to do something about it? =========================...

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Ive tried and tried to find this... but i just cant seem to find any help with it. I have no trouble in changing my Y axis to a log scale... but i cant seem to find a way to add the log scale to the X axis. The 'scale' options that i see for the X-asis are just simple things like inverting the data adn the locations of the information on the graph. Can someone help me figure this out... In article <59bb656f.-1@webcrossing.JaKIaxP2ac0>, jeffus13@officeformac.com wrote: > Version: 2008 > Operating Sys...

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, <br> I have a big problem with a chart I have created a simple chart with this values: <br><br>X Y <br> 1.13700	 0.39213 <br> 1.46200	 0.23851 <br> 1.63300	 0.13124 <br> 1.87500	 0.04913 <br><br>and I add a trendline , when I extract the formula the scope value and the interceptor value are wrong, If I try to calculate the same value with excel formule (SCOPE - INTERCEPTOR) I obtain a corre...

Is there a way to have a logarithmic graph ignore the cells that contain a 0 value or no value in the graphed range?? Thanks ahead of time for the help. Log(0) is infinite. What do you propose instead? Logarithmic graphs do ignore cells that contain no value. Do you perhaps mean that it is not ignoring cells that contain zero length strings? Try using =IF(<condition>,<formula>,#N/A) instead of =IF(<condition>,<formula>,"") or =IF(<condition>,<formula>,0) Jerry John Babcock wrote: > Is there a way to have a logarithmic graph...

Does anyone know how to create a line chart that displays both the X AN Y axes in logarithmic format -- bobpanke ----------------------------------------------------------------------- bobpankey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1516 View this thread: http://www.excelforum.com/showthread.php?threadid=26799 Bob, Most charts are category charts. On the x axis are equally spaced categories (Apples, Oranges, etc.), and their associated values are plotted on the Y axis, optionally logarithmically. It sounds as though you need to plot points, with b...

I have a data set, and when I choose to add a trendline, I can't select the logarithmic trendline option. Ive tried changing my initial value from 0 to 0.1 in my data set, but this only enables the exponential trendline option. The log trendline equation is y=a*ln(x)+b. Clearly it doesn't allow x <=0. OTOH, the exponential trendline equation is y=a*exp(b*x). It can be transformed into a linear form with ln(y)=ln(a)+b*x. It doesn't allow y<=0. You may also want to look at an article I wrote: Trendline coefficients http://www.tushar-mehta.com/excel/tips/trendline_coef...

Hi I have plotted a chart using a logarithmic scale - is it true to say that on a logarithmic scale the distance between the points are proportional - whereas on a linear scale the distance between the figures are relative?? Thanks In a word: NO -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email <miriamlight@gmail.com> wrote in message news:1157445149.864746.180940@p79g2000cwp.googlegroups.com... > Hi > > I have plotted a chart using a logarithmic scale - is it true to say > that on a logarithmic scale > the distance between the points are prop...

Can someone please tell me how to display a log base 10 equation for a logarithmic trendline in an excel chart Multiply the coefficient of ln(x) by ln(10). Alternatively, get the coefficients in the worksheet by selecting a 5 row by 2 column range and entering the array formula =LINEST(range-with-y-values,LOG10(range-with-x-values),TRUE,TRUE). To enter an array formula complete data entry with the CTRL+SHIFT+ENTER combination rather than just the ENTER or TAB key. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 200...

In Excel 2007 if you create a XY Scatter Plot and then add a polynomial trendline to the plot, display the equation, then try and copy/paste the chart to a Word 2007 document the trendline equation in the chart drops one of the orders. If you right click and select Format Trendline, it still lists the correct order equation, but it does not show. If you delete the trendline, and then add it again in the pasted copy of the chart the problem is fixed. I have reproduced this using 2,3,4,5, and 6th order polynomial equations. I was unable to reproduce this behaviour. Can you give more ...

I have a graph which uses a primary & a secondary Y axis. The trendline works fine for the series which uses the primary Y axis, but the series using the secondary Y axis adds a trendline based on the primary Y axis. Am I doing something wrong? thnx When you use the Add trend line dialog check that the trend line is based on the correct data series. phil6666 wrote: > I have a graph which uses a primary & a secondary Y axis. > > The trendline works fine for the series which uses the primary Y axis, > but the series using the secondary Y axis adds a trendline based o...

Hi Guys Is it possible to sum trendlines, or simply series, in excel charts? I have a large spreadsheet recording financial expenditure in respect of about 10 different job numbers, with each of these graphed on the chart showing trend lines. The problem is, if you simply chart the data in aggregate in order to find an overall trend line for expenditure, ie. set the source data to the various columns under each job number, there are large numbers of transactions under different job numbers on the same date, which means that these transactions aren't summed but appear as different points ...

As previously reported, I used scatter chart. However, my data are bellow 1 (0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y axis on the left keeping these values? Thanks Charles - To change the location of the Y axis on an XY (Scatter) chart, select the horizontal X axis, choose Format Selected Axis | Scale, uncheck the box for "Value (Y) Axis Crosses At," and specify an X value. - Mike www.mikemiddleton.com "Charles" <Charles@discussions.microsoft.com> wrote in message news:9D9C9721-D0E9-439B-9A85-159BFA940254@microsoft.com... > ...

Ok, I apologize if this is a stupid question, but I'm really confused about a result from Excel's trendline options. My data is below: X Y -0.15 -1.05 -0.14 -0.98 -0.13 -0.65 -0.12 -0.6 -0.11 -0.33 -0.10 -0.3 -0.09 -0.2475 -0.08 -0.22 -0.07 -0.1925 -0.06 -0.12 -0.05 -0.1 -0.04 -0.08 -0.03 -0.03 -0.02 -0.02 -0.01 -0.01 0.00 0 0.01 0.005 0.02 0.01 0.03 0.015 0.04 0.02 0.05 0.025 0.06 0.03 0.07 0.035 0.08 0.04 0.09 0.045 0.10 0.05 0.11 0.055 0.12 0.06 0.13 0.065 0.14 0.07 0.15 0.075 You can see from the data that the rate of change in the Y values increases quickly as X increases, henc...

Hi, would any of you know of a site where i can find information regarding X and Y axis logarithmic scaling ? Thanx What kind of information? To use a log scaled axis, double click the axis and in the resulting dialog box, from the Scale tab select 'Log scale.' To use axis values other than powers of 10, see the Excel/Tutorials/Flexible Log Scale page of my web site. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article <197b501c44d74$20458ab0$a601280a@phx.gbl>, euvaldojr@ig.com.b...

Hello I am wanting to do a Log Plot (both Axis) on the following data. How do I do this in Excel? Stage Discharge 0.291 0.873 1.237 11.6 0.7 5.16 0.295 0.889 0.288 0.783 0.288 0.811 0.288 0.771 0.48 2.53 0.284 0.737 0.333 1.12 3.261 44.8 0.378 1.53 0.389 1.63 0.444 1.978 0.325 0.96 0.306 0.932 0.301 0.855 0.82 6.87 0.834 7.26 0.877 6.57 1.045 9.18 1.764 18 3.121 39.9 4.297 68.9 4.526 77.6 3.085 30.5 0.087 0.061 With the data in A1:B28: First select all the data (and headers) and use Data|Sort to sort by Stage Now select A1:B28 and make an XY chart Double click x-axis, open Scale tab and...

How would the following Chart equation be resolved in Excel: y = 147832x2 - 150195x + 2E+07 Thanks! Please explain what you mean by "be resolved" To get the trendline values into cells see http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "soccerkatie" <soccerkatie@discussions.microsoft.com> wrote in message news:FA5E6D19-13E3-40CB-8238-6B4AF88A26F2@microsoft.com... > How would the following Chart equation be resolved in Excel: > > y = 147832...

Hello all, I realize that a negative or a zero plot on a logarithmic scale is meaningless. However, many times I'm working with data that is full of noise an non-ideal, i.e. it contains zeros and/or negative values. I still would like to plot them on a logarithmic scale. Excel does this quite well and ignores the negative/zero values on the chart. However, IT PRODUCES A WARNING EVERYTIME I TOUCH THE CHART! I make tons and tons of these graphs, so in order to save what little sanity I have remaining, I must find a way to turn this warning off. Please help me. Hi, Try using a...