Has anybody else had this problem? If one uses a 6 order polynomial as
trendline and then s/he enters manually in an other column the same equation
taken from the displayed trendline equation on the graph , the original
trendline is different from the one manually entered. Excel plots the two
different curves having the same equation!!!
Please see an example at : http://www.geocities.com/audax/error.xls
Thank you for the help.
Disregard the previous message. The problem is due to the rounding off. The
trendline calculation is OK.
See my website for the use of LINEST to get coef...Is this UTF-8 regular expression semantically correct?
> BYTE_ORDER_MARK [0\xEF][0\xBB][0\xBF]
> ASCII [\x0-\x7f]
> U2 [\xC2-\xDF][\x80-\xBF]
> U3 [\xE0][\xA0-\xBF][\x80-\xBF]
>...insert worksheet gives me 3 duplicate sheets not one
I do insert worksheet from the Insert menu, I only have one tab highlighted
and I get 3 duplicate worksheets as opposed to an new worksheet. Also when I
open excel if get the worksheet i expect but if I open a new sheet I get one
with some spurious numbers in it. I've tried making sure that there's
nothing in XLstart or in the file line under options>general>at startup, open
files in.. that's blank. So I would have thought I was back to the default
settings but this doesn't seem to be the case. I have tried doing a
re-install from the office disc and doing a ch...Add Trendline to Pivot Table Graph
I have a list of survey responses and I have created a Pivot Table with Month
as the Row Heading and Count of Respondent as Data. I have then created a
Pivot Table chart.
I want to show a trendline but when I select the columns and right click for
Trendline, as I would normally, the option is greyed out.
How do I create a trendline for the pivot table category columns?
If Add Trendline is disabled with a pivot chart (I don't know, I rarely make
pivot charts), you could plot the data in a regular chart, then add your
Pivot Tables, Pivot Charts, and Real Charts...Trendlines in graphs
Hi all! I have an interesting question. I am ploting a
graph where the X axis is by months and the Y axis is the
number of parts produced. Some months we do not produce
any parts; therefore, the Y axis is "0" at that time.
When I put a trend line on the chart, it sees the "0" as a
computable data point. A line is then generated but is
off from the true trend. The true trend can be generated
if I remove all the non producing months. Is there a way
to specify specific groups of cells in a column that you
want to use in a trendline analysis--sort of hop scotch ...summing results of multiple vloopups
Can anyone help with the following vloopup formula?
If there is a value in all three ranges it returns the currect amount.
Here are the problems:
- If RANGEA is missing a value it does not add RANGEB and RANGEC.
- It RANGEA and RANGEC are missing values it adds RANGEB to a value from
the cell above.
Nothing wrong with the formula although it ...Can someone give me a script please
Could someone give me a script to do the following please?
In the Customer table there are over 500 records.
Most of them have 3 digit numbers eg 423
The last 50 or so have 6 digit numbers eg 000475
I want to change all the 3 digit ones to add 3 leading 0's to the number ie
to make 423 into 000423
This should get you were you wanna go:
SET AccountNumber = '000' + AccountNumber
WHERE LEN(AccountNumber) = 3
Retail Information Technology Enterprises (RITE)
320-230-2282 ...weighted trendline
Can anyone tell me if it possible to weight a linear trendline in excel?
Like a calibration line where you can weight by 1/x where x is the variance
at each point on the line.
I don't believe that can be done with anything built into the trendline
chart feature, but you can use the trendline formula in the spreadsheet and
then apply your weighting to it. Then plot that rather than the built-in
trendline. You can get the formula of the trendline from the chart by
choosing to display it or in the spreadsheet by using the LINEST function or
the related SLOPE and INTERCEPT func...Excel currency format does not translate correctly in a Word merge
When I merge an Excel file with various fields/formats, the currency formats
[seven different columns with currency] the Word file displays 70 instead of
$70.00. What do I need to do and in which file?
"ILoveMyCorgi" <ILoveMyCorgi@discussions.microsoft.com> wrote in message
> When I merge an Excel file with various fields/formats, the currency
> [seven different columns with currency] the Word file displays 70 instead
> $70.00. What do I need to do and in which file?
Exc...vat adds up correctly accross spreadsheet but down the columns whe
I have a very basic spread sheet which adds VAT to various cost figures.
I have a total VAT cell below the VAT columns. When adding the columns
together the answer is normally out by 1p less.
Total VAT should be £110.96 but Excel calculates at £110.95 The above
calculation may be a bad example but the above occurs when the VAT is rounded
up or down against an individual cost figure. So why is the Total different
if the sum is just the adding up of the VAT individual totals?
because 17.5% ...Booklet used to print correctly #2
My company just updated to MS Office 2007.
I have a small booklet in Publisher that used to print perfectly, now pages
are upside down.
I’ve read previous posts, even tried smaller paper.
Ahhh, please help…
When you say "small", do you mean 5.5 x 4.25? The service pack corrected this
Description of 2007 Microsoft Office Suite Service Pack 2 (SP2) and of Microsoft
Office Language Pack 2007 SP2
"Pam" <Pam@discussions.microsoft.com> wrote in message
news:17339...IE8 BUG - CSS zoom
Open a page with an image and a map with areas. Use the Developer tools to
add the css style="zoom:50%". Higlight a map area tag in the tool and you
will see that the areas are not in the correct position or the correct size.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agre...Increaseing Precision in polynomial trendline equations
How can I increase the precision in Excel's "Display Equation" option
I am trying to fit a polynomial regression (trendline) to a X, Y
scatterplot I have created.
Excel's built-in trendline function shows a good fit (R2=0.9999) for a
6th order polynomial, however, If I re-plot the data using the
coefficients from the "Display equation" option, the data diverge
Apparently, for high order polynomials, you need to have a high level
of precision in your coefficients (many decimal places accurate) in
order to actually re-plot the same ...Trendline
How can I create multiple trendlines on one graph i.e I have a graph with 5
years data and I want to show a linear trendline for each year on the same
You need each year plotted as a separate data series, then follow Mike's
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Carlo" <Carlo@discussions.microsoft.com> wrote in message
> How can I create multiple trendlines on one graph i.e I have a graph with
> years data and I wa...editing data using a form
I'm thinking what should my approach be, to do a simple data edit
correctly. I've got a table with 1500 jobs, User can scroll throufgh
the list, filter, etc, etc, and I want to enable him to edit details
of a particular job. Because the data is quite vulnerable and users
are quite prone to type sth in or change sth without noticing, I
wouldn't want the details to be changed whenever a user changes them
on a form and moves a focus to another control.
IS there any simple way to achieve that that I just don't know about?
Cause if I just make a form.recordsource bein...Powerpoint crashes abruptly when using RMB for spelling correction on pasted text
3 out of 5, if I use RMB to open the context menu on a word that is not
recognized by spell checker to correct it or add it to dictionary,
Powerpoint 2003 crashes abruptly IF the text was pasted from another source
(any) rather than filled in by typing. I suspect that pasted texts may
contain some hidden markup that may create problems to spell checker. The
point is: is there a way to see what is REALLY inside a PPT text box?
Dario de Judicibus
...quickly give GP users access to mod screens / reports
Is there a method to quickly give users that have access to specific screens
/ reports, only access to the mod versions of all those resources?
An article in Knowledge Base describes this - see Q20
However the solution described here is very cumbersome, and requires that
you first investigate which specfic users have access to which specific
For instance, one client has 100+ users at 10+ companies, with 200+ mod's.
To give all users access to mo...Excel: Can I force a linear trendline through the origin?
Yes, open at the Option tab when you make (or format) a trendline
There is a text box to set intercept to any value (including 0)
Bernard V Liengme
remove caps from email
"Bill" <Bill@discussions.microsoft.com> wrote in message
I have done that, but it is not working. Perhaps it is because I am plotting
a log-log graph and therefore there is no actual zero value for the y-axis.
But I need the line to pass through the origin, and because the data covers
severa...correct total column in flitered list
This is a multi-part message in MIME format.
correct total column in filtered list
I have a list(table in 2007) as bellow
Does anyone know how to choose the correct trendline for a data set? I
have plotted a data set in Excel 2007 (located at the following link)
but I don't know how to choose the correct trendline from the options
The 'correct' trendline depends on the data. If I weight 2 bags of sugar,
then 4 bags, then 5 I would expect the trend to be linear. But if I measured
the area of circles of different radii, then I would need to use a second
order polynomial with zero intercept. And so on.
What is you da...Remove Trendline
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: imap
How do I remove a trendline? This is very frustrating. <br><br>Even at 200% zoom there is no way to click on the trendline. The cursor remains a crossed arrow. If I right click on the data line, there is no choice for removing a trendline, only for adding new trendlines. <br><br>Robert Rose
So I see I posted this to the wrong Forum. Shows how frustrated I am.
I can simply click on the trendline, and it gets highlighted. You have to be
Can anyone help? I what to add a logarithmic trendline but the option is greyed out and I can't seem to find where the addin might be. I am working with Excel business 2000.
There is no add-in. Sounds as if the data is not amenable to a log fit.Are
there negative values? Is the x-axis numeric?
"Gee" <firstname.lastname@example.org> wrote in message
> Can anyone help? I what to add a logarithmic trendline but the option is
greyed out and I can't seem to find where the addin might be. I am worki...Placing Trendlines Behind Data Points
Is there a way to get the trendline to show behind the points? I have an XY
(scatter chart using just the points (no lines). I added a trendline to get
a nice parabolic curve. Normally I would use the connected option when I
pick the chart type, but the resulting line does not fit as well as the
Not that I know of. The trendline shows within open marker with a white
Bernard V Liengme
remove caps from email
"Sloth" <Sloth@discussions.microsoft.com> wrote in message
news:3D4A7967-EF8C-4B9A-9F76-E280F235E...cannot see trendlines
I have a graph with 6 series. There is a primary and a secondary X
I want trendlines (moving average) on all data series. The chart will
not show any. No error messages, go through procedure of adding
trendline, but it just doesn't show up. Search for hidden line with
cursor, doesn't show.
The trendlines show up in the legend whether or not they show up on the
Scaling is automatic, and there is space above and below the data curve.
...Word 2007 Equations not displaying but printing fine
I have a Word 2007 document and I have inserted some equations (Insert tab,
Equations) and after I get done entering the information and click elsewhere
alls I see on the page is a white box with a black border. The funny thing
is when I print the equations display. If you go into the Word Options,
Advanced, I have it checked to display text boxes and drawings and still