Creating a chart with text not numbers
How do I create a chart that has text values (freshman, sophomore, junior,
senior) instead of numbers (1, 2, 3, 4)?
I have a column labeled "What is your class standing?" and below it is 166
rows where people selected "Freshman," "Sophomore," etc. I want to create a
bar chart that counts how many people selected each of the four classes.
First of all, you will have numbers to plot. The words are your category
Read how to turn a column of words like this into a histogram:
- Jon...How to add another user's Contacts folder to my Address Book?
Background: Exchange 2003 Server w/ Outlook 2000/2003 clients.
I can add any Contacts folders in my mailbox to my Address Book by going
into the Properties of the folder and checking "Show this folder as an
e-mail Address Book" on the "Outlook Address Book" tab. However, if I have
another user's mailbox (to which I have full permission) in my Folder List,
I do not have this option in any of their Contacts folders.
How do I add another user's Contacts folder, displayed in my Folder List, to
my Address Book?
After a bit of research on SlipStick.com...Reinstall Money on New Hard Drive
I installed Money Plus Deluxe on a desktop and a laptop, which expires Feb.
2010. The hard drive has to be replaced on the desktop and probably won't
last much longer. Since I already activated Money twice, my understanding is
that my choices are to purchase another copy of Money Plus to install on new
hard drive and use until it expires in 2011, or purchase Quicken now to
convert files and then re-install Quicken on new hard drive. Or would I be
able to download my backup files of Money on new hard drive and then convert
to a fresh install of Quicken without doing the con...Formatting number in Data Table
I am using Excel 2007. I have a spreadsheet that the figures can be
negative or positve. I have formatted the cells with this custom
format $#,##0;[Red]$-#,##0. On the spreadsheet the format works fine.
I created a chart from the data. I have a data table at the bottom of
the chart. The problem is that the format from the spreadsheet is not
reflected in the data table. When I click on Format Data Table, there
is no option for number formatting. There is a number formatting
option available when i click Format Axis, but this doesn't change it,
because the actual axis is Text.
Is th...Find the number of years between two dates
I have aroster of players with thier date of births. I would like to
automatically add their ages in another column
Try this Formula, assuming that the dob is in cell A1
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"
> I have aroster of players with thier date of births. I would like to
> automatically add their ages in another column
On Fri, 9 Sep 2005 19:47:02 -0700, "duke" <duke@disc...Office 2004 Project Gallery
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
In the main screen of the Office 2004 Project Gallery, there are icons for
things like �Mail Message� and �Calendar Event�. How can I add, for example,
�Address Book Entry� or �Task� to the Project Gallery?
<HTML...Add a new code macro
I have workbook that I am trying to use with a macro form another post on
this form. It inserts a new row with the formulas and contents of the
selected row. The problem is that it copies the row below the one selected,
and because of this, I can not make a copy of row 2 below the column headers.
Any ideas? Thanks. Here is the code:
'/=======Start of Code==========================/
'adds desired # of lines below the current line and
' copies the formulas to that/those lines
'added selection of more than one worksheet
' - Gary L. Brown
...I can add an extra calendar, but can't share it??
At my workplace we have a dozen of calendars for the rooms we use,
- Meeting room1
- Meeting room2
and so on. Now we have calendar-books for each of them, and every time
I want to reserve a room or the car I have to walk at least 50
I thought it would have been nice if we could use Outlook calendar for
this, I have now added a calendar, but it's not possible for anybody
else to open it..? why?
Are there better ways of doing this?
(I know there are web-calendars and so on, but outlook would be much
In ne...Limited User can't use Money
I've installed Money 2004 in hopes to clear this same
problem I had with 2001, to no avail.
I installed Money 04 with my System Administrator acct.
It works fine for me. But when my wife tries with her
Limited Account, she cannot get access. How do I get her
access to this program and data? I've tried installing
it in the All Users dir, but no help. I really don't
want to give her Sys Admin priveleges just to use Money.
Thanks to anyone that can help. MS Support has no info
on this, nor does a Google search turn anything up.
If she creates a new Money file, can you b...Void trans. Money 2006 doesn't recog.goes to same transaction/bug?
In my checking acct. I entered a check number and it had to be voided.
When I try to to go to a new withdrawal, it starts with the number that was
just voided instead of going to the next check, is this another bug?
I tried closing the program and restarting but does the same thing.
They fix this in 2007 also? Seems the more I work with 2006, seems to be bug
infested and they want you to buy 2007 to fix it?
I just tried this in M07 and M04. I entered # 2111. Then I voided it. Then I
went to enter another new transaction. In both versions, It started the
transaction by auto-fil...Money using wrong date to calculate ROI YTD
I have opened a new file in Money to track investments for
a stock club. I entered all transactions, which go back
to Jan. 2002. When I look at performance for the account,
the ROI YTD is not accurate, as Money is using values for
the stocks going back only 6 months form the date I enterd
the transactions rather than the values as of 1/1/03.
What to do?
In microsoft.public.money, Brooks wrote:
>I have opened a new file in Money to track investments for
>a stock club. I entered all transactions, which go back
>to Jan. 2002. When I look at performance for the account,
&g...page numbers in Word 2007
I have a Microsoft Word 2007 document which has a title and
table of contents on the first page and the various chapters on
the following pages. I have used an automatic TOC and then
clicked on the Insert tab and then Page Number -> Bottom of
Page to insert page numbers.
My problem is that I don't want the first page to be numbered
so that the second page starts with the number 1.
I have tried clicking Page Number -> Format Page Numbers...
to set the first page number at zero but then when I delete the
zero all page numbers are deleted by Word 2007 just as th...Switch from Money 2003 Deluxe & Business-> Money 2003
I just purchased a new computer and Money 2003 is
preinstalled. On my other computer, I was using Money
2003 Deluxe and Business. When I loaded my backup in
Money 2003, I received a message that since the previous
version was for business, I would not be able to access
my business accounts. Not a problem. The problem that I
am having is that all of my balances are -$170,999,999 on
every account and that a bugdet and cash flow are set
up. I can't figure out how to make this right, and get
the correct balances updated.
Thanks in advance for the help.
In ...pivot table 05-01-10
I have data on two worksheet and i want to analize data by consolidate them
togeter.How can i use pivot table?
> I have data on two worksheet and i want to analize data by consolidate
> togeter.How can i use pivot table?
Yes, you can use mutliple sheets connected to single pivot.
choose, Multiple consolidation ranges option in Pivot table and Pivot
Chart Wizard - step 1 of 3.
It is better to get the all data into single sheet and use pivot.
--...Recurring Bills Glitch in 05
I noticed an earlier thread describing a problem where bills no longer
showed up anywhere but the calendar view. I am seeing something along
the same lines but my bills show up normally for the next two months,
then nothing in November. In December, I again get a full list but
January only shows one entry.
The calendar view shows everything so it seems the glitch is confined
to the line-by-line display.
I had a pretty large automatic update download into Money today, but I
can't say for sure if this problem just appeared. I had not noticed
it the previous two days after upgrading fro...Error 1004 Workbooks.Add Inplace-Activation
I don't know if I am in the correct forum
but here it comes any way
this simple macro only works from the debugger environment if I have XL
Is there any workarounds ?
Best regards Magnus
Is it so that XL has a state that it cannot do this ?
Do I have to change state to
pItem->DoVerb (OLEIVERB_OPEN, pView ); ????
"Magnus Pettersson" <firstname.lastname@example.org> wrote in message
> Hi !
> I d...Money 2005 Calendar
Is there any way to pring out the bill calendar? Quicken
allowed you to do this and it was one of the more awesome
features in Quicken.
...Money is Having PASSWORD Problems.
Several Money users have not been able to access they
Money data since early this week. Microsoft is working on
a solution, They will post here when they have it!
No WAY, really?
>Several Money users have not been able to access they
>Money data since early this week. Microsoft is working
>a solution, They will post here when they have it!
...Upgrade From Money 2004 to 2005
I was running Money 2004 Deluxe with no problems and then
converted to Money 2005. When I click on the Portfolio
Manager icon, the screen that appears only has today's
date, "Portfolio Manager", and "Quotes delayed at least
20 minutes" below the dark blue line that starts
with "investing Home".
Nothing else is on the page below the blue line...no
investments, and no menu on the left.
I could sure use some help on this one....
...Disabling Microsoft Money Background Banking Service (mnybbsvc.exe) in 2007
I found the instructions for 2008, which is a simple check box in the
settings, but is there any way to disable it in earlier versions?
In microsoft.public.money, Milhouse Van Houten wrote:
>I found the instructions for 2008, which is a simple check box in the
>settings, but is there any way to disable it in earlier versions?
You could remove your LiveID.
...Any add on products I can use with SOP
We are trying to keep track of our orders that are not ready to be processed
for reasons such as waiting for approval from customer, waiting for confirm
ship date, needing customization and therefore take longer in production...
We want to be able to add a comment that has a date and an action date. Date
is the date someone enter in a comment, action date will be a date when
someone needs to follow up. We need multiple dates and multiple comments for
a single order and do not want everything type together in one comment field.
We already have collection main module and we can use so...Editing phone numbers?
(Win XP, Outlook 2003) - I'm all of a sudden starting to have a problem
when I add or change a phone number in a contact. I'm connected via
LAN, not dialup, and no settings have changed. Yet when I put in a
phone number I get the Location Information dialog box (this box:
I can NOT get out of it in any way except using the task manager to End
Task, which of course does not save the contact. If I try to cancel in
the dialog, it just keeps coming back. Any changes except phone numbers
work fine. It's only when I...Money 2008 #4
Is Money 2008 usable in the UK, and how can I obtain it?
Yes it is usable but it cannot read a previous UK Money file. Also if you do
go down the USA version route and MS decide to produce a UK version in the
future then you would not be able to upgrade.
Note that it is lined up with the US fiscal rules on capital
depreciation/gains tax and various other annoyances - chief of which is the
inability to spell cheque!
The only way you can get M2008 USA is to download it from the MS site. Note
you cannot have a CD version and you need to quote a USA address - 1600
Pennsylvania Avenue, Was...Converting string to number
I have a set of data that is to be cut and pasted from an external
A typical cell reads '32813.58 sq mm', without the speech marks.
The cell could be formatted before the pasting; but how do I strip off
the units to leave the number only? The number could be any size.
Will return your data as required as long as the text to be stripped is
Please hit "Yes" if this post was helpful.
> I have a set of data that is to be...Cell Number Format
when i type for example this any number with more than 15
digits, the first 15 digits appear like i wrote it but the
rest of them are changed by zeros.
EX: i write this 123456789123456789
and the number that is kept is 123456789123456000
Does anyone experienced this and knows how to resolve it.
As you can verify in XL Help ("Specifications"), XL is limited to 15
decimal digits of precision for numbers.
If you're entering, say, a credit card number, which doesn't require any
math to be performed on it, you can preformat the cell as Text or prefix