Trend Lines #2
We are conducting some research on welding and have some X-Y data plotted
where the Y axis corresponds to # of Inclusions, and the X axis is thickness.
I have done a Scatter Plot, and wish to add a Trend Line.
The question is: what is the difference between a Linear and Logarithmic
If you type the word TREND into Excel help, one of the topics is:
Equations for calculating trendlines
http://office.microsoft.com/en-us/help/HP052078071033.aspx?pid=CH101178621033and also see http://office.microsoft.com/en-us/excel/HA010877851033.aspx--David Biddulph"PA&qu...Remove Duplicates
How can you remove filter records which are the same in 3 to 4 columns only
the ones that have in all 3 columns same wording
> How can you remove filter records which are the same in 3 to 4 columns only
> the ones that have in all 3 columns same wording
Assume the 3 cols are cols C to E
In F2, copied down: =SUMPRODUCT(--MATCH(C2:E2,C2:E2,0))=3
Then apply n autofilter for TRUE in F1, delete these filtered rows
please explain more detailed
also if we don't want todelete only copy the filte...CRM v4
I have a marketing list that contains more than one person from a company
(for some companies). I want to be able to remove the duplicates based on
title. Example: I want to be able to filter the list so if there is a CIO,
CFO and CEO I want the CIO and remove the CFO and CEO. If no CIO then keep
the CFO and remove the CEO. If no CIO or CFO then keep the CEO. The key is I
want the list to have one person per company but not exclude any companies.
I am pulling the list from Leads. Does anyone know if this is possible in
...Adding a text/line from Drawbox onto graph
I have a graph that is being updated weekly, so every time the X-axis
I add comment texts and / or pointers/lines to the graph from time to time.
The problem I have is that each time I expand the graph (X range increases),
I have to manually move the comments - because the graph is being rescaled.
Is there any way to link the additional elements on the plot to be moved
with the X-scale?
Replace the textbox comments with a comment in a Data Label. If you only
want one comment, select the series, then single click the data poin...messaging between property page and formview
My desired result is two-way communication between the active property
page and formview. User clicks on a button on the property page that
updates a control on the formview and vice versa. I can create user
define message for the formview and property page but how would the
(active) property page send a message to the formview and vice versa? I
shouldn't need pointers to each class or do I? This is what I'm trying
VC 6 w/ sp 6
> My desired result is two-way communication between the active property
> page and formview. User click...How do I copying data from a cell on sheet to a diff cell/sheet
It data entry of scores on worksheet one that has to be automatically copied
to worksheet 2. Once I entry the data on wksht 1 want it placed on wksht 2.
I run tournaments, need all of the date on worksheet 1 but only some on
worksheet 2 so I can sort it. When I set up my wksht 2 us the formula
=wksht1!C4 on the first line. the on the second line input =wksht1!C11
then highlight the two and drag it down. It will copied what i inputed but
won't calculte and change the cell referrence by 7 how do I get it to do that
without having to manually change the number?
To get ...Remove commas at end of line only
I have a column which contains part of an address eg.
"Honeyhouse, High Street,"
Is it possible to remove the comma at the end of the line but not the other comma?
for each c in selection
"Mark" <firstname.lastname@example.org> wrote in message
> I have a column which contains part of an address eg.
> "Honeyhouse, High Street,"
> Is it possible to r...Removing Hyperlinks
I am sure I have seen this question before on this newsgroup but can not
seem to find the thread.
Is it possible to remove hyperlinks in bulk from a worksheet or must they be
done one at a time?
Delete extra @ to reply
You can copy a blank cell and then Paste Special | Add to your selected cells.
However, this does add a zero to formulas...
= A1 + B1 becomes... = A1 + B1 + 0
San Francisco, USA
"john.bedford3" <john.bedford3@@ntlworld.com> wrote in message
> I am sure I have seen this ...Removing "Maximize" from system menu.
I have a dialog based application. I want to completely remove the Maximize
and the Size entries from the system menu. They are grayed now, but I want
them totally removed. I just want a cleaner look since these will never be
How do I do this?
You could try making the main dialog have a Tool Window style set. It will
be smaller, but it looks nice.
"Paco" <email@example.com> wrote in message
>I have a dialog based application. I want to completely remove the Maximize
>and the Size entries f...How to select multiple sheets using macro
I want to select multiple sheets using macro in the
I tried recording the action and it gave the following
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Actually i want to copy all the sheets in the current
workbook and move it to a new workbook..
Hence the next line would be:
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).copy..
which would copy the selected sheets to a new workbook..
Now the problem is, the sheet names mentioned in the code
are fixed,, whereas i want to select the sheets
dynamically in...How do I create a button to print this page?
Ok I am on the Microsoft Script Editor. I still can't figure out how to
assign a macro to a button that will allow others to print this web page.
Where do I install the script on the source page.
When I post it anywhere a button does not appear on my editing page
...Sheet tab properties
Hi again. This is my last question. :)
Are there in Excel sheet tab properties so that i can choose font, text
color or something else not just tab colour? And can i have those sheet
tabs in two or more rows? because my workbook has a lot of
sheets(something like 100 sheets) and it's confusing when you have to
find a sheet .
I don't think you can change anything other than tab color. With so
many sheets you could devote sheet1 to being a table of contents with
buttons or hyperlinks or whatever which display sheet information and
a click takes you to that she...Dotted line to remove
I have just been editing a multi-page word document and something I did has
made a dotted line appear. It goes across the page from margin to margin.
Whatever I do to try to remove it doesn't seem to work. The line was not in
the original so some I assume some key or setting I have touched has done it.
The Word I am using is MS Office Word 2007 - something I find is a lot more
fiddly than the older version I have used for years.
Any help would be appreciated.
<>>< ><&l...Remove existing property sets doesn't remove
I have created a new custom property sets in Visio 2003 Professional and it
will not allow me the remove the existing property set and replace it with my
...Printing an Email Message (but only 1 page)
Hi, when I go to print an email (in Microsoft Outlook), I
press "file", then "print", and usually I get a window
asking "Print pages -- "all" or "page numbers.." etc, but
I don't always get this screen. Sometimes, (depending on
the email), I get "print all pages, print only odd pages,
or print only even pages".
How can I only print the current page, all the time?
...remove column in all email views
I put some add in to my Outlook 2003 about 8 months ago that was
supposed to help me keep track of my emails. I did not like it and
uninstalled it. However, any time I create a new mail folder now
outlook automatically makes a thread and categories column. How can I
get it to stop this behavior?
I would also like a way to remove all the categories and thread columns
in all my folders so I don't have to go into each folder and do it by
hand. I am a programmer so doing it programmatically is not an issue.
...ADC removal problem
I want to go to native mode now that our Exchange 5.5
server is shut down but I cannot because I get an error
saying all connection agreements need to be removed.
I was able to remove 2/3 connection agreements, but now i
can't remove the 3rd. Config CA_SITE_SERVER
The 5.5 server has already been removed from the 2003
Check out the following article, specifically step 12:
272314 XADM: Preparing a Mixed Mode Organization for Conversion to Native
You need to remove the SRS, which will automatically take care o...Frontpage 2003, can you change the page dimensions?
My website is enormously wide! How can I shrink it down to the standard size?
> My website is enormously wide! How can I shrink it down to the standard
..NET: It's About Trust! http://vfred.mvps.org
Customer Hatred Knows No Bounds at MSFT
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Free usenet access at http://www.eternal-september.org
What is the standard size?
I use a fixed width layout set to 760px wide. This fits every screen (excluding mobiles) currently in existence, bearing in mind that most wide screen...Removing/changing online Payees
I would like to change/delete/combine some of my online
payees. I know that you cannot combine online payees. Is
it possible to change an account so that it is no longer
an online account, then combine or change all the online
payees that I'm interested in, and then finally make the
accounts online accounts again?
...Wrong dates on chart exported as web page
When I export an Excel workbook containing 2 charts and a
spreadsheet the graphs display the wrong date range along
the bottom of the charts. The data is showing the data
which it should be, i.e. all of it, but for some reason
the dates are all messed up and only show part of the
date range. Excel is not missing out some dates - it is
just getting them completely wrong. Does anyone have any
ideas for fixing this?
...Will restoring CRM 3.0 databases to remove bad data cause offline client issues?
We recently did an import into our CRM 3.0 install, and would like to
restore our CRM Db's to remove that data. If we have Outlook clients that
are currently online, but have gone offline and back online agains since the
bad data was imported, what will the effect on them be? Will the data that
is removed from restoring the databases still be on the laptops? Or will the
next time they go offline will it be removed?
...Removing a keystroke
Is there a way to remove all spaces within a column of cells? Extra spaces
are screwing up my subtotals. Thanks!
Select the cells to want to fix and then use Find/Replace
Gary''s Student - gsnu200909
> Is there a way to remove all spaces within a column of cells? Extra spaces
> are screwing up my subtotals. Thanks!
Select the column
what: (space character)
with: (leave blank--not even a space character)
Did you get this data from a web site?
If yes, then you could be seeing those...How do I break a hyperlink in an Excel document?
I have several hyperlinks to graphs within an Excel document, just on
seperate tabs. Now when trying to clear the contents and just type text into
that cell, it will not release the hyperlink. It only allows me to delete
the entire row or column, which I don't want to do because I would have to
re-create the entire document.
How can I simply break the hyperlink within the Excel sheet?
"Fulchp47" <Fulchp47@discussions.microsoft.com> wrote in message
news:A5F06...how do i move columns on one sheet to columns on another sheet
I have sheet one which is column "A" student's name columns "B thru K" are a
point system in each column (by 3 points either a score of 1, 2 or 3).
Column "L" is the total points summed across "B" thru "K". (a total of no
more than 30).
Sheet 2 is 5 columns with each column being worth 6 points. Column "A" is
25 thru 30 points, column "B" is 19 thru 24 points, column "C" is 13 thru 18
points, column "D" is 7 thru 12 points and column "E" is 0 thru 6 ponts.
I need column ...Removing older versions of MS Money
I notice that I have MSMoney 2000 and 2003 in my Add/Remove Programs.
I am getting ready to upgrade to 2007 because Money says it won't
update my investments any longer. Can I safely remove the MS Money
2000 (I assume it is there because I must have decided to install 2003
in a separate location and then import my money file, rather than
simply update MS Money 2000) ? I don't want to do anything to mess up
my money file.
Also - anything I should be mindful of when upgrading MSMoney 2003 to
the 2007 version? Surprises I might not like,etc?
You shouldn't have a pro...