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?
In A1:A10 enter your resistance values (the x-values)
In B2:B10 enter the RH (meaning?) values (the y-values)
Sel...How do I write a trendline constant into a cell?
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...no trendline option available
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 ...logarithmic scale in excel?
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
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
--...0 on a logarithmic axis
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
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.
"E" <E@discussions.microsoft.com> wrote in message
news:D416CA9D-CD05-41...Trendline on chart created from pivotable
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?
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.
Select a blan...logarithms
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>
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...Rounding in Trendline Equation
An Excel logarithmic trendline attached to a data series has the following:
R2 = 0.9533 (a good fit for the data)
Final value (where the trendline crosses the right-hand (secondary)
~420,000 (the value I’m ultimately seeking)
I have created a new series with this equation to create the same curve with
Final value produced with this formula: 195,673 (obviously not close
Excel value ~420,000)
Changing the “-3E+06” value to 2,600,000 produces 414,873 –...Logarithms
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?
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>,
> Version: 2008
> Operating Sys...Scope value In trendline chart incorrect
Operating System: Mac OS X 10.6 (Snow Leopard)
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...Logarithmic graph
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
John Babcock wrote:
> Is there a way to have a logarithmic graph...Logarithmic Chart
Does anyone know how to create a line chart that displays both the X AN
Y axes in logarithmic format
bobpankey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1516
View this thread: http://www.excelforum.com/showthread.php?threadid=26799
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...Re: Logarithmic Trendlines in Excel
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
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
You may also want to look at an article I wrote:
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??
In a word: NO
Bernard V Liengme
remove caps from email
<email@example.com> wrote in message
> 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...Logarithmic trendlines
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
To enter an array formula complete data entry with the CTRL+SHIFT+ENTER
combination rather than just the ENTER or TAB key.
Custom business solutions leveraging a multi-disciplinary approach
In Excel 200...Ploynomial Trendline Equation Changes After Copy Paste
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
I was unable to reproduce this behaviour. Can you give more ...Trendline Question- Graph with TWO Y Axis???
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?
When you use the Add trend line dialog check that the trend line is
based on the correct data series.
> 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...Summing trendlines in excel charts?
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 ...In the x axis, logarithmic scale
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?
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.
"Charles" <Charles@discussions.microsoft.com> wrote in message
> ...Logarithmic Trendline
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:
You can see from the data that the rate of change in the Y values
increases quickly as X increases, henc...Logarithmic scale
Hi, would any of you know of a site where i can find
information regarding X and Y axis logarithmic scaling ?
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.
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <firstname.lastname@example.org>,
Hello I am wanting to do a Log Plot (both Axis) on the following data. How
do I do this in Excel?
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...Resolving Polynomial Trendline Formula for Chart
How would the following Chart equation be resolved in Excel:
y = 147832x2 - 150195x + 2E+07
Please explain what you mean by "be resolved"
To get the trendline values into cells see
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"soccerkatie" <email@example.com> wrote in message
> How would the following Chart equation be resolved in Excel:
> y = 147832...negative/zero values on logarithmic plot warning
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.
Try using a...