change the text in the legend of a chart w/o changing pivot text
I am trying to create a series of pie charts that compares demographic data
for clients assisted with multiple housing-related activities (new homebuyer,
rehab, foreclosure prevention, etc.) If I want to look at the age of new
homebuyers, on my pivot table I deselect all activities except new homebuyer.
After I make my pie chart, in the legend the labels are "new homebuyer
18-24", "new homebuyer 25-34", etc. It's pretty self-explanatory that these
are all "new homebuyers". I need for the New Homebuyer part to not be shown
in the legend, but I can...Changing Function to use a Date Input
can anyone please advise me on how to change the function keys.. sa
F10, F11 & F12 to use to input a date into a cell.
F10 to be 01/01/04
F11 to be 02/01/04
F12 to be 03/01/04
What I require is to go to any cell and press the relevant function ke
to Input the associated date
Any help would be greatly appreciate
PS using Excel 200
Message posted from http://www.ExcelForum.com
First, I'm not sure if you entered Jan 1, 2004, Feb 1, 2004, and Mar 1, 2004 or
Jan 1st-3rd, 2004.
Here are a couple of macros. The first turns this on, the second turns it...How do I size a Word Document to 5 x 8 inches?
I'm trying to size a document in Word to fit book or pamphlet that is 5 x 8.
But I'm having a terrible time. Is there a way to size a document in Word to
this size? I have Word 2003.
From the File Menu, select Page Setup and then go to the Paper tab and via
the Paper size pulldown, select Custom and then insert the size of your
Note however, that some printers have difficulty with "Custom Sized" paper
and it may be necessary to use a standard size sheet in Word (8.5 x 11) and
adjust the margins so that the print area coincides with the area on whic...Changing Default DURATION value of 30 min. in activities
Is there a way to change the 30 min. default value in
activity types? Even if through the database?
The Duration field is represented as a picklist on the activity form. Picklist values can usually be customised through the CRM user interface which would allow you to change the default and add additional values. However, at present the CRM Activity form is not customisable through any supported method. Maybe in a future release.
...How do you change the data and input data into a chart on Excel?
Jon Peltier's Excel chart info may be useful to you.
"unclemoko" <email@example.com> wrote in message
...moving data from one sheet to another
I have records in sheet1 as follows:
A B C D E
1 NAME SEX SUBJECT COLLEGE WHETHER SELECTED
2 A MALE MATHS XAVIER YES
3 B FEMALE ENGLISH SEBASTIAN
4 C FEMALE MATHS PAULS
5 D MALE PHYSICS XAVIER YES
6 E MALE CHEMISTRY PAULS YES
7 F MALE PHYSICS SEBASTIAN YES
8 G FEMALE MATHS XAVIER YES
9 H MALE PHYSICS PAULS
10 I MALE MATHS SEBASTIAN
Now, I want to scan entire data upto last cell of the
range and move(cut and paste) those of the selected candidates, Sheet2
of the same book.After moving, the name o...Changing data from imported .txt file
When i import data from an old (dos based) program negative numbers appear
with the minus behind the number. Does anyone have any idea how i can change
them all from 1,234.56- to -1,234.56 so Excel will recognise them? Changing
them by hand takes forever. Thank you.
If you're using xl2002+ and are using File|Open to open a text file, you'll see
a wizard popup.
On step 3 of that wizard, there's an advanced button.
There's an option to treat trailing minus signs as negative numbers.
If you already have the data in the worksheet, you can use...
Dana DeLouis pos...How do I change headings for columns from numbers to letters? #2
...Sharing Outlook 2003 .pst on 2 computers (not simultaneously)
I hope someone can help me here. I have 2 different offices, both
running outlook 03, and i would like to find a way to carry the .pst
with me, on an ipod, or USB memory stick. can you do this??
i run into the situation where i need to access email on one computer
when i'm at the other office. i get a stupid amount of emails during
the day, so i have to touch each one twice. i'm trying to figure out
a way that i can have just one disk, portable media or put the file on
a vpn server, so when i launch outlook (only one will be running at a
time), they use the same .pst file. This m...How do I change the user ID for a financial institution?
I had to change my user ID for chase.com because someone kept trying to hack
into my account and locking it. Where within Money 2006 can I change my user
ID for a particular financial institution? I see where I can change the
password for a financial institution, but not the user ID. Thanks.
=?Utf-8?B?TWljaGFlbA==?= <Michael@discussions.microsoft.com> wrote on
03 Jan 2008 in group microsoft.public.money:
> I had to change my user ID for chase.com because someone kept trying
> to hack into my account and locking it. Where within Money 2006 can
> I change my user ID for ...cells changing from number to date
I am putting a number in a cell, then tabbing to the next cell, the previous
cell changed from a number to a date. How do I keep the number there?
What are you inputting, a fraction?if so, format as # ??/??
(remove nothere from the email address if mailing direct)
"firstname.lastname@example.org" <email@example.com@discussions.microsoft.com> wrote in
> I am putting a number in a cell, then tabbing to the next cell, the
> cell changed from a number to a date. How do I keep the number there?
...Number lock key on the computer key pad
I have come across a weird situation with respect to number lock key. Before
the transaction I make sure that the number lock key is ON, then I scan few
items, and after I finish the transaction I find the number lock key is
automatically turned off.
So on next transaction I have to manually turn it on to punch the tender
I have tried rebooting the computer, resetting the key pad, resetting the
scanner, but none helps. Has anyone else encountered this condition, and is
there any fix for that?
Never seen it happen.
Here's a link to always tur...one sided posting entry in gp?
how would I create a one sided entry in GP to correct a double sided entry
that posted twice ( due to a system failer a month ago)? There used to be a
document on customer source; but i cant find it.
Thanks for any information
I'm unclear as to why you need a one sided entry instead of backing
out one of the double sided entries that posted incorrectly.
To backout one of those entries click "Correct" on the JE Transaction
Entry Screen (Transactions->Financial->General)
On Sep 18, 12:54 pm, 2020 <2...@discussions.microsoft.com> wro...Custom Paper Size For Publisher
I've created 2 custom paper sizes using the "Print Sever Properties" method
as suggested by Microsoft and yet neither of these new forms are being shown
in Publisher (or word) in either Page Set-Up or Printer Options.
Any ideas as to why?
You have no idea about setting up print servers.
Suggest you find somebody that knows what they are doing in setting up print
"aghent" <firstname.lastname@example.org> wrote in message
| I've created 2 custom paper sizes using the "Print Sever P...Unwelcome color changes
Any clues what went wrong here?
I've been using a spreadsheet for about 2 years. It gets used almost
everyday. Over time I've created perhaps 6 or 8 custom colors in the
color palette. The sheet is all numbers and I have used color
extensively to highlight various cells.
Yesterday for the first time I created a new window while using this
spreadsheet and had different workbook pages open in each one. I
updated data in only one window. After a while I saved the file and
exited, then backed it up.
Today when I opened it I found these problems with the colors. First,
all my custo...Change public folders
I setup HMC 3.5 and created a new public folder store for hosted accounts.
Every account i setup gets an error on send about the offline address book,
error no. 0x8004010F
I believe this is caused because the organizations are using the hosted
folder store, not the default public store. Looking through system manager,
all of the folders seem to be created in the Public folder store but the HMC
ResourceManagerWebClient/QueryResources.aspx displays the organizations
under the Hosted Public Store. How do i move the organizations between the
two folder stores?
myarmush at real-war...cell value goes up by one count
Could i get some help with this.
How does one get an activecell , that has a value of 1, that is copied from
sheet1 to sheet2 so that the value changes from 1 to a 2 and so on depending
on how many times I copy a sheet.
I hope this makes sense
Thanks in Advance
I think you are asking for this formula. It will change the value of current
cell (doesn't matter on which sheet you are currently working) to value of
Sheet 1's A1 cell. Means if Sheet 1 A1 = 100 and you are currently working on
Sheet 2 F1, then this formula will show the F1 value ...Changing the way the home page looks in M07
I got a new widescreen monitor for Christmas.
Is there a way within Money 07 to change the home page layout to allow more
than two columns of customized items?
Also - off topic - since Road Runner no longer supports news readers, does
anyone have a suggestion on how to pick one which offer good value at low or
"Mark Fields" <email@example.com> wrote in message
> I got a new widescreen monitor for Christmas.
> Is there a way within Money 07 to change the home page layout...Window sizing
it In GP10 is there a way to size a window and they keep that size the next
time it is opened?
For example I open the cash receipts apply window 30 times a day. And each
time I have to size to fit the screen. What am I missing?
You would need to either write some VBA to have the window open Maximized or
you can use modifier to reset the window size.
If you use Modifier to reset the window size you will need to manually
resize the fields though so it would end up being tedious.
Consulting Technology Lead
The views or opinions expressed in th...How to change a publication's start page number
I have created a series of publications and I want to start page numbering
for each publication at a specific number..........it was able to be changed
under Tools>Options in 2002 but I can not find this feature in Publisher
2003. Can anyone help? Thanks.
Wombat146 <Wombat146@discussions.microsoft.com> was recently heard to
> I have created a series of publications and I want to start page
> numbering for each publication at a specific number..........it was
> able to be changed under Tools>Options in 2002 but I can not find
> this feature in Publisher 2003....How can you change the text layout of the calendar?
I would like to change the text layout of the weekly calendar. The week is
set in 2 lines. I would like to put set it in 1 line (August 1-August 7). I
would also like to have the day (Monday, August 1) set on the left hand side
of the page, rather than the right side.
You can extend your "Work Week" to all 7 days and then use the Work Week view
to get all days on the same line, but you can't change where the date header
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve...Government Applications One Focus of XML 2004
XML 2004 to Focus on Government XML Applications
Expanded Government Track to Highlight XML Applications in U.S. and Abroad;
XML.gov, KM.gov, CIO Council, and SICoP to Co-Host Event
Alexandria, Va. – Oct. 6, 2004 – IDEAlliance, a leading industry
association dedicated to fostering XML and other information technology
standards, today announced that XML Conference and Exposition 2004 will feature
a full track of presentations and topics focused on government-related XML
applications and solutions. XML 2004 is slated for Nov. 15-19 at the Marriott
Wardman Park Hotel in Washington, D.C.
Ma...Auto start up with non-xls files
When I load Excel (either from Start of double clicking on an xls), Excel
starts up and loads a number of things automatically; some database scripts,
exchange files, and one of two others (none are .xls). My guess is that all
these files (and perhaps Excel) were open at a time when I had to boot the
computer, and something is now telling Excel that these files need to be
Is there someway I can tell not to load these?
If you have Excel open Go to Tools | Options | General | In the bottom half of
the tab open there will be a line that says "At st...How do I change the public folder structure/heirarchy
We are using Exchange 2003 Server and the Public Folder Heirarchy is
incorrect. All folder begin two levels down from the Root. Example below.
All Public Folders ( Here is where all folders have been created)
We want to move everything so that they folders are created at the top level
under Public Folders. What methods are possible and what is the least
painful way to ge this done thanks.
...Is it possible to share a style change across an organisation
I would like use a consistent style for the Word documents in our
organistaion. The style we want to use is 'Formal' but with the colour of
underlining changed from brown to blue. How can I create or edit or use a
corporate style across our organisation so that everyone has access to it
without having to make the colour change manually each time?
You need to set up the styles in a template and then distribute that to your
users with instructions that they use that template as the basis of the
documents that they are to create.
See the article "Creating a Template...