y-axis moves from the left hand side to the right hand side
Using the XY (scatter) graph normally gives a scatter graph with the y-axis
on the left hand side, but for some reason with my data the y-axis has moved
to the right hand side. How do I avoid this.
This is also posted in .charting. And replied.
mvpearl omitthisword at verizon period net
"JP" <JP@discussions.microsoft.com> wrote in message
> Using the XY (scatter) graph normally gives a scatter graph with the
> on the l...How to automatically change a single letter text entry to caps??
Hi to everyone
Hopefully someone can help! I have a spreadsheet where users input a letter
from a to z into a textbox. How can I make Excel convert this letter to a
capital letter automatically, in case someone enters it as a lowercase
letter? Dont know if this can be done, but hoping it can!! I know about the
UPPER function, but that is not quite what I need as that function enters the
letter as uppercase into another textbox. I need it as uppercase in the
textbox in which it is entered.
I asked a similar question some while ago and received the answer that it
ca...CRM 4 and SQL upgrade
I have a CRM 3 installation on a SQL 2000 box which is also the CRM app
Planning for the CRM 4 upgrade, I have a new physical server with SQL 2005
What is my most efficient upgrade path?
I think you can do the following:
1. Move the CRM 3.0 database to SQL 2005.
2. Point the CRM 3.0 application to the new database server. (There's
documentations on how to move database to a new server on the
3. Install/Upgrade CRM 3.0 to CRM 4.0 on the CRM 3.0 application
I think this is the fastest and easiest in my opinion.
Darren Liu, Microsof...Pivot Tables #4
When I double click to drill down to the supporting data
in a pivot table, the data is displayed on a new tab
within the workbook. Then to close that data, I have to
delete the tab.
1) Is there a faster way to view then close the data
without having to delete a tab every time?
2) If I leave the new sheet open, is it linked to the
pivot table? In other words, if I refresh the pivot
table, will the data on the new sheet be automatically
refreshed as well?
#1. I don't think so. But maybe you could apply Data|filter|autofilter to the
original da...Out of Memory #4
I have an application that is used by over 8000 users worldwide. There
are several that are reporting an "out of memory" problem using one of
the functions in the tool. One user just received a brand new laptop
(T41) and is now encountering this error. It was working on their old
laptop. The function that they are trying to run when they get this
problem opens up another excel spreadsheet and then selects sheets from
the first spreadsheet and then copies it into the second spreadsheet.
It goes through a loop and does this for each sheet. It is only
copying the values and forma...formatting based on text
I need to format several docs every day. They're programs written in Notepad
and any line that starts off with <! is a comment. My job is to copy the
text from Notepad and change all comment lines to be white text with a black
background. Is there some way for Excel to do this automatically?
I know there are other programs besides Notepad but this is what I'm stuck
with doing so I can't change the process.
You said you are copying it from notepad, is the final result going to be in
excel or not? If it is you can use excel autoformating.
...Macro to copy text between two different delimeters
I am trying to write a macro in Excel to select text between cells
which contain words.
1.) I need to search for a cell that contains only one-single word
"item:" and then copy the contents of the cell just-above that cell
2.) I need to search for a cell that contains only one-single word
"component(s):" and then copy all of the rows below that until I find
a cell that contains only the word "Zip"
Any samples would help for either of these challenges
This is just an example of technique, not a full solution. This macro
searches the activ...Bolding text
Operating System: Mac OS X 10.5 (Leopard)
This is such a fundamental function that I can't believe I'm asking a question about it. However, every time I try to bold or italicize certain words in my document, Word makes changes to the entire document. For example, I highlight two words in a section header, hit 'Bold' on my toolbox, and the everything is bolded.
Has anyone else had this problem? Can you help?
With the cursor in a problematic word, click on Format | Style. Click
Modify. UNCHECK automatically update, and CHECK add to temp...Retrieving JUST text from a node with child nodes
Can't seem to figure out how to retrieve the text of a node with multiple
child nodes (and I just want the text of the parent, not the InnerText or
InnerXML that comes with it).
My doc looks something like this:
<parent attrib1 attrib2 attrib3>
some more text
yet more text
What's the best way to return "Extractable string"?
You can either just select the text via an XPath expression like this:
or, if your XmlD...spreadsheet #4
having trouble finding the proper spreadsheet for windowsXP...I HAVE A XLS FILE TO OPEN, anyone used a spreadsheet, that could direct me? Thank you
Windows XP is an operating system. You also need to have a version of
Excel as well.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"rick" <email@example.com> wrote in message
> having trouble finding the prop...2007 print merge 4 postcards/4 different addresses per page
I have read the previous posts regarding this issue. I cannot resolve my
I have created a 1/4 page postcard. Information on page one and successfully
merged addresses on page two. I only have one postcard on my screen and as I
scroll through, I see all the correct information in the merge.
I am having trouble printing the merge. I want 4 postcards on one 8 1/2x11
piece of cardstock. One side with the same information and the other side
with four different addresses from my merge. I am getting side one with
information and side two with four duplicated addresses. The second pi...How to Enable Print on Both Side(Duplex) on Windows 2004
When seen on the Print options for the Printer added on Windows 2004 I
am not finding the "Print on Both Sides (Duplex) option...Can any one
let me know...how to enable this option on Windows 2004..I know there
is such option for Windowx XP...But dont know how to do this for wn2K4
...Excel 2007: Wrap Text
I have merged a number of cells, set wrap text, and set AutoFit Row height,
but the cell will not wrap and adjust height.
This works for non-merged cells. This function surely must work for merged
According to most reputable sources, *nothing* works properly where merged
cells are involved... including the stability of the file. However, you've
asked about this in the Mac Excel group so if you'd like to have it echoed
you may want to post in the Win Excel group. Get there from"
http://www.microsoft.com/office/community/en-us/Flyout...delivery restrictions #4
I have a mailbox that is used only to receive fax attachemnts emails from a
service that a phone company provides us.
I want to allow only emails coming from this domain
(*@voicemail.telepacific.net) to be allowed in this mailbox.
How can I chieve this? The delivery restrictions area allows only specifying
internal addresses but the address I want to allow is external.
On Thu, 10 Aug 2006 19:28:32 -0700, "Perecli Manole"
>I have a mailbox that is used only to receive fax attachemnts emails from a
>service that a phone...Error 4.4.7 -
We are not able to deliver mail from our Exchange 2003
server (part of SBS) to certain domain names including
hotmail.com, microsoft.com and msn.com. Here is the
messages that we get.
First message from Exchange..
This is an automatically generated Delivery Status
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.
Contents of attached text message (ATT04044.txt.) sample.
Final-Recipient: rfc822;Gary.Megson@fds...Excel-can't turn off multiple cell selection or add text/numbers
When I open a spread sheet and left click my mouse in a cell, I can't enter
any data. If I move the mouse, it highlights the cells the cursor touches
and I can't turn that off. Hitting the Esc key does nothing. I'm locked out
of all the toolbar functions. The only way I can terminated the program is
by going to task manager and 'end task'. The EXT indicator isn't on, but
even if it was, I should be able to get out of it by hitting F8. If I try to
X out of Excel by going off the page and selecting anything, the cells just
keep getting highlighted. Yes, I'...please help #4
Please guys I really need some help with this, I'm at my witts end.
We are using sbs server 2000 with exchange. If and email is sent to one of
our users say firstname.lastname@example.org with an other address in either the to/
cc/bbc fields, say email@example.com. Exchange is routing the
same email from the orgianator (spoofed) to the second address. so that the
other address recieves two copies as if from the original sender, but it
your servers that are send it out.
Now I'm asssuming this is a relay problem, but can not find any why of
Your help would be greatly ap...FLIPPING TEXT
HOW DO YOU FLIP THE TEXT FOR AN IRON ON TRANSFER TO PRINT CORRECTLY
Can your printer do a mirror image?
Might try WordArt.
Select the text box, copy, paste special as a .wmf, flip...
Mary Sauer MSFT MVP
"MIA" <MIA@discussions.microsoft.com> wrote in message
> HOW DO YOU FLIP THE TEXT FOR AN IRON ON TRANSFER TO PRINT CORRECTLY
On Fri, 10 Feb 2006 18:06:28 +0000, MIA wrote
(in article <EA27CE71-2642-4A76-850C-6EBE2AC31BB1@mi...NDR 4.4.6?
I get the following error when attempting to send to a particular DL.
A configuration error in the e-mail system caused the message to bounce
between two servers or to be forwarded between two recipients. Contact your
How do I check the possibility of looping?
Do the users in the DL have forwarding turned on within their mail
properties in AD?
"pscottlee" <firstname.lastname@example.org> wrote in message
>I get the following error when attempting to send to a particu...10.1.4 can't find an installation???
I have Office X SR-1 installed, and whenever I try to upgrade to the 10.1.4
(Exchange update), the installer fails telling me it can't find a valid
installation to upgrade. Office is located in the Applications folder of my
hard drive and is a legal copy, so I don't know why it won't install?
Thanks in advance!
On 10/3/03 8:35 PM, in article BBA3B855.28Eemail@example.com,
"Mailinglists" <firstname.lastname@example.org> wrote:
> I have Office X SR-1 installed, and whenever I try to upgrade to the 10.1.4
> (Exchange update), the installer fails tel...column width #4
I thought it would be much easier but I can't set column widths from VB
After lot of trouble I find out that ColumnWidth is not what I need, i
sets width in characters not in pixels. How can I set width in pixels
I need full synta
AFAIK the width property is read-only. So you can only use ColumnWidth
> I thought it would be much easier but I can't set column widths from
> VB. After lot of trouble I find out that ColumnWidth is not what I
> need, it sets width in characters not in pix...need a refresher: text boxes on charts that use relational formulas?
I could have sworn that a long time ago, I set up one or more text boxes on
a graph that had formulas in them, so the text that was showing would
automatically change each month.
I'm now using Win2000/XL2003, and not having much luck- I want to put my
legend on the bottom, then a text box under it where I will show 3 values
(one for each legend item) to provide some additional information on the
graph. I have too many graphs to do this and have to update it all manually.
What is the best approach to use, to link the contents of my text box (or
similar) to the contents of a cell that on m...templates #4
template won't come up after download, a validation succuessful screen
appears and I can't find downloads>?
Why don't you give us more details, what template are you downloading and
from where, exactly - give us the entire url.
If this helps, please click the Yes button.
> template won't come up after download, a validation succuessful screen
> appears and I can't find downloads>?
...text messaging to exchange 2007
I'm not sure this is the correct group for this. Does anyone know if text
messages can be sent to an exchange 2007 mailbox?
> I'm not sure this is the correct group for this. Does anyone know if
> text messages can be sent to an exchange 2007 mailbox?
Yes, they can - just like any email address - my wife does it all the time
from her Verizon phone.
Sure enough, I tried it and it works just fine. Thanks!
"Karl Mitschke" <karlmits...error #4
no se me instala el excel, ser� la versi�n antigua que no me deja?