R squared not the same in graph and spread sheet.
I have an X-Y plot displayed with a trend line equation and R squared. I
also calculate R squared (RSQ) and the numbers are not the same; 0.8918
and 0.928. Can someone explain this (Excel 2010 and Windows 7)?
Extraneous "not" in Reply To.
"James Silverton" <firstname.lastname@example.org> wrote:
> I have an X-Y plot displayed with a trend line equation
> and R squared. I also calculate R squared (RSQ) and the
> numbers are not the same; 0.8918 and 0.928. Can someone
> explain this (Excel 2010 and Windows 7)?
You would need to post  m...Change <value> in outlook
We Have Exchange 2003 sp2 and outlook 2003 sp2. I have renamed 2 AD
accounts. Changed all display names, accounts name etc with the 2 accounts.
When users open outlook and send to renamed account they see account name
<oldaccountname> in the autocomplete list. I have cleared nk2 files in
profile , but it still shows newaccount <oldaccountname> in drop down box. Is
there a way to edit the <oldaccountnam> value of the renamed account? I
tried the same thing with a freshly loaded PC. with the same result.
You can delete the nickname files.
MVP - E...Has Anyone ever seen a chart like this?
Looking for some help. I need to know what this column chart is called?
Or how to make it?
'CLick Here to View Chart'
I can't find any option in Excel to make this chart. Maybe it was not
made in Excel? Or I need a specific plugin?
TsunamiBob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36202
View this thread: http://www.excelforum.com/showthread.php?threadid=559874
Formula or VBA?
I am trying to create a formula to assign a region to populate a chart. I
know there is a way to use the OFFSET function to point ot a certain section
of a data sheet, but what if i insert a line between the title and the
data.(done programmactically)? the problem is that inserted lines do not
automatically include into the data range for a chart.
The data wants to be sorted from newest to oldest. Would it be easier to
create a formula to assign a 'chart data area' or simply reassign the data
area every time the table is updated
Thanks for the input.
...Changing Interface OWA (exchange 2003)
Not sure if you all remember but back in the Exchange 5.5 days we use to be
able to go onto a site and put in the username of the person mailbox you
want to access, then a windows pop up would come up asking you for your
credentials. I was wondering if that is still possible to do that in
Exchange 2003? If so how can that be done?
Configure Forms-Based Authentication (FBA).
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"John" <email@example.com> wrote in message
> Not sure...chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the
number of the column I want to chart (these numbers are listed as labels in
I can't figure out how to translate the number in S4 into the corresponding
column letter. For example, if S4 contains "3", the chart title should be
I think working with absolute references, R1C1, might be easier here, but
somehow what I've tried, didn't work (the entire spreadsheet is based on
relative addresses (A1).
in a cell (Z100) put
Change G2 to whatev...Multiple PST Files #2
I am running Outlook 2003 and would like to have Outlook use two
different .pst files (one for my work stuff and one for home) on the
same computer. Is it possible to do this?
If so, can I can I configure one of the pst files to get e-mail from
one account, while the other pst file is configured to get mail from
the other account?
Yes, you can create multiple PSTs. I keep mine stored in
the same file location but with different names.
Depending on which version of Outlook you run, you can
creat a new pst from file/new/Outlook Data File (I run
Outlook 2003 but had multiple P...DEADLINE... PLEASE HELP! Stacked Bar chart?
I'm not even sure how to ask the question so here's what I have...
2003 2004 2005
Actual/Goal Actual/Goal Actual/Goal
Me 1009/1061 591/866 658/897
Comp. A 966/1012 633/811 624/808
Comp. B 699/744 450/593 480/607
Comp. C 957/1005 642/821 665/838
I wanto to show a bar for each competitor, for each year, so there will be 4
bars for each year. Each bar showing Actual performance & Performance Goal...Font problem
It seems that the Cambria Math font has recently acquired an extremely large
Ascent and Descent. Has it perhaps always been that way and I've never
noticed it before, or is it something recent, perhaps a Vista thing? Try the
following code for example. For Arial and Times New Roman (and virtually all
other fonts) I am getting pretty much exactly what I would expect (a
TextHeight that is a bit larger than the point size) but for Cambria Math I
am getting an extremely large TextHeight (I get exactly the same results
using GDI32 methods). At this end (on my Vista Business laptop...Change License / Company name
we tried CRM 1.2 with the MSDN license key. Now my company bought a 25 user
Proffesional Suite license and I want to change the key on the production
server. Is there an easy way to do this??
The only solution I see, is via the Data Migration Framework.
How about the re-deploy tool?
"Erik" <none> wrote in message news:u0SXdbXlEHA.3452@TK2MSFTNGP15.phx.gbl...
> we tried CRM 1.2 with the MSDN license key. Now my company bought a 25
> Proffesional Suite license and I want to change the key on the production
> server. Is there an easy wa...Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my
classes.(Alphabetized names down left vertical column. Dates across
top of horizontal row.) I added a different color to all cells in
every other row to make for easier reading of each student's name and
absences. Every other row stays with a white background.
My question: I wondered if it was possible to lock row colors while
allowing data to change on top of them. If a new student is added to
my class in alphabetical order, the alternating color pattern is often
lost. It is a pain to rechange row and cell colors.
Any shortcut ...gp10 change clients pointing to different server
In version GP 10 I have clients pointed to a test server. When production
server is ready what do i do to point the clients to the production server
Would I change the odbc connection?
Rerun the client installs?
Any help is appriciated.
As long as your production server has THE SAME level service pack as your
clients and THE SAME third party products all you need to do is repoint your
ODBC to the production server.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
"2020" wro...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...Background changes conditionally
I have a spreadsheet that shows the floor plan layout of my call
On each desk, the desk number and identity are displayed. I would like
to colour the background for those pcs that are on the same subnet.
I have a sheet called data - it contains Table Number, Desk Number, PC
ID, IP Address.
How could I get it to change the background colour if the pc is on
subnet 162, and set a different colour for those on subnet 167
PeterG's Profile: http://www.excelforum.com/member.p...Multiple Bar Codes Per Item
I'm looking to use Microsoft RMS for a medium sized game store with
one terminal. One critical feature is the ability to have multiple bar
codes assigned to the same item. Can RMS do this?
If you are talking about multiple part numbers, yes, use the alias function.
Remember what a barcode is. Its a graphical representation of a partnumber
that is machine readable. It doesn't describe the item, it is only a number
to reference that item. Just like your phone number, it means nothing, but
everytime someone dials that number, it gets to you.
"gareman" ...multiple look ups
A B C D E F G
1 PO TRANS $ $ AMT $ AMT QTY QTY
# TYPE AMT RECV VCHR RECV VCHR
2 4227 RECV 668 668 0 26 0
3 4227 RECV 2,415.80 2,415.80 0 94 0
4 4227 VCHR 722 722 0 26
5 TOTAL 3,084 722 120 26 2362.34
For column F and G, I need each QTY RECV to have a matching QTY VCH
(***See note at bottom) whereby ultimately, the total RECV QTY equal
the total VCHR QTY w...collating information from multiple sources
Apologies if this has been asked before, but I'm a bit of a newbie when
it comes to mucking around in excel, I've had a search but I don't
really know what to call what I want to do, so finding the answer is
Anyway. I have a dozen or so workbooks that are all of the same
format, 1 work sheet with a basic list of test scenarios in each, with
a unique reference for each row.
What I'd like to do is pull information from all those workbooks into a
separate workbook by the use of the unique reference. i.e If I type
in the unique reference in the master workb...stop automatically changing formula!
i have a countif function
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")
How do I stop it from changing column I to J?!?!?!
MS Excel MVP
"caryn" <firstname.lastname@example.org> wrote in message
> i have a countif function
> when i copy this and paste it to the nex...How do I combine two worksheets into one graph
I have two worksheets on an Excel spreadsheet. I would like to take both
worksheets and place in one graph. Any suggestions?
Make a chart with data from one sheet. Then copy the data on the other sheet, select
the chart, and use Paste Special from the Edit menu to add the copied data as New
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I have two worksheets on an Excel spreadsheet. I would like to take both
> worksheets and place in one graph. Any suggestions?
...unable to change password via OWA
I am having a problem with users changing passwords via OWA. When they click
on the change password button, it comes up with change password screen and
asked for domain name, user name , old password ,etc. The problem that I have
is that when I submit it, it comes up with message saying "Either the
password is too short or password uniqueness restrictions have not been met."
But I didn't define any password policy on DC.
What can I do ?
Kindly please give me some idea.
If you are running windows and exchange 2003 then there are password
requirements that...How do I lock a chart so it will not update?
That's the question. I have my data in Excel and the chart in Excel but not
all the data cells are used. Everytimg I open the chart it wants to update
and I want it to stay the same.
Any ideas on how to lock the chart?
Just a few ideas:
You could lock the cells that are shown in the chart.
Or you could copy the cells and paste as values (assuming formulas were used
that update when other cells change).
http://www.wimgielis.be = Excel/VBA, soccer and music
"Locking a Chart" wrote:
> That's the question. I have my data in Excel and the chart in ...find match then change cell value
In column A I have cells filled with text and in column B I have cells filled
with numbers. I need to check if the number in cell C1 equals any of the
numbers in column B. If a match is found then I need to change the text in
column A to CBO.
Column A Column B Column C
aep 5 7
Since the cell C1 = 7 equals the 7 from column B, I need to change the data
in column A from xle to cbo. Is this possible...How can I reset the default pie chart label "Other" to "Equity"?
I show Cash, Equities, and Fixed Income in the large pie to the left. The
equity slice is further split into large, medium, and small. The problem is
that the Equity slice gets relabeled as "Other". When I manuallly change it
back to Equity, I lose the ability to link to any new data...so I can't use
the pie chart as a template that would allow me to put new data in the table
and have the pie chart adjust automaticially. How can I reset the default
pie chart label to "Equity"? or is there another solution.
Instead of making pie charts (which are notor...Multiple Item Forms
Hi. I am new to your form and am struggling with the Multiple Item Forms. I
want a combo box on the top that will select an id number from a table called
'SurveyA'. The multiple item form should then only display the records in a
table called 'ActTravDiary' with that id number. As the ID number is changed
a new group of records should be displayed in the form.
I know how to initiate a change in one combo box based on another combo box
(i.e. Row Source), but I cannot find a similar property for the multiple item
forms. Please help.
On Fri, 12 Feb 2010 21:00:2...OWA - change password
Getting the "Object Required" error, when somebody is trying to change their
password through OWA. (Win2003/Ex FE 2003)
Any ideas what could be causing this?
Did you follow the steps in:
Pablo D. Vernocchi
Microsoft Exchange MVP
MCSA + M / MCSE + Sec
"Per Hagstrom" <email@example.comNOSPAM> wrote in message