Question re: Chart
I have a chart with source data in E27:F29 (let's say Sheet 2).
On a separate sheet (Sheet 1), the chart links to the above data.
E27 = Current Month F27 = $ 5,000
E28 = 31 - 60 Days F28 = <$ 2,000>
E29 = Over 60 Days F29 = $15,000
It's a bar chart w/ the bars going horizontally, and the labels for each
bar are on the left and the values are shown at the top of the chart.
Now, for some reason, the labels for the X Axis only show "Current Month"
and "31-60 Days" but DOES NOT show "Over 60 Days" ... I'm not sure why it's
...Template Wizard with Data Tracking
I have been using this add-in just fine for about a year,
gathering data from about 20 users onto an Excel Database
by having them all use the template. But I recently made
some changes and then began having the following
problem: After a worksheet has been created using the
template, and saved as a new record in the database, and
then we want to go back in to change the record and
update it in the database, the option does not appear to
update the database; the only options continue to be to
create a new record or to proceed without saving to the
database. It is as though the sys...copying and pasting question
Is there a way to copy data lets say from column A1 to A* from one
spreadsheet, into lets say row 1 of another spreadsheet
If * is less than 257, you can select your range (a1:A99 say) and then
select A1 of the second worksheet and then
Edit|paste special and check that Transpose box.
(256 columns is the max in excel.)
> Is there a way to copy data lets say from column A1 to A* from one
> spreadsheet, into lets say row 1 of another spreadsheet
great i'll give it a try
"Dave Peterson" wrote:
> If * is less than 257, you c...Message Tracking #6
What is the best way to check if your exchange sometimes doesn't accepts
mail (delay) or doesn't send mails correctly (delay) Message Tracking ?
But how do you actually do this
"Guillaume Coign�" <firstname.lastname@example.org> wrote:
>What is the best way to check if your exchange sometimes doesn't accepts
>mail (delay) or doesn't send mails correctly (delay) Message Tracking ?
>But how do you actually do this
Assuming you're asking about messages leaving your organization, the
SMTP protocol logs are the place to ...How do I track half days in the attendance tracking template?
I've just created an attendance tracking template in Excel, however realized
that there isn't an option to track half or quarter days taken off.
Does anyone have any suggestions?
A lot depends on how you've laid out the data. Instead of tracking
whole days, can you track hours? 8 for a full day, 4 for a half day,
...Track Changes compatibility between versions of Excel
I'm planning to undertake a project which involves Excel sheets
created in Excel 2003 and tracking the changes made to those sheets
via Excel 97. Does anybody know of any problems with the compatibility
of this function? This would help me out a lot. Thanks.
...Weekday function question
In my excel worksheet I have a column (say Column A)with a series of
dates (11/30/0l3, 1/10/04, etc). I would like to be able, say in
Column B, to see what day of the week the certain date is. I have
looked thru the instructions for the Weekday function, and it is
beyond me. Can someone give me a simple formula which I can place into
the first cell of Column B and copy all the way down, so that in
Column B it will be a weekday corresponding to the date in Column A?
To reply by mail, remove 'nick'.
http://www.geocities.com/mhc_repo...Tracking GST/VAT in MSMoney Standard
I'm new to Money & processing small business accounts. Had no problems
tracking & reporting VAT in Quicken & havegot Money to calculate VAT with
each relevant entry. Somehow just not finding a report that shows VAT
totals, taxable income etc. Please HELP!!!!!
...Outlook 2000: Any way to track Calendar access
I've opened up my Calendar for anyone to read in Outlook 2000. Is there any
way to track who accesses it?
...How to track meetings for a task?
How would you suggest to charge meeting time to a my Timesheet task? TIA!
Depends on if it's a planned meeting or informal. I typically just create
a bucket task through the entire schedule for "Meetings" or book it to PM
time. You may also opt to create a distinct line item bucket task for status
meetings as opposed to other ad hoc meetings.
If it's a big phase gate meeting, I may list that specifically as a line
item, but for anything less than that, it becomes too granular for effective
- Andrew Lavinsky
Blog: http://blogs.catapultsystems...track Shipment
Is it possible to set up the Track Shipment so when you click on TRACK it is
automatically bring up a browser with the tracking information?
For UPS what will be the URL to set up?
...XY Scatter question : 2 data for each point (x and y)
I would like to create the following chart.
Let say I have for each region (region1, region2 etc...) the share in the
total population and the share in the total income.
ex. Region 1 : 5% of population 15% of income (rich)
Region 2 : 20% of population 5% of income (poor) etc ....
I would like the % of population as the x-axis and the % of income as the
Each region will be a point in the diagram.
The diagram has two parts : poor and rich with different colors
I'm not sure I understand - it seems to me you have answered your own
question - you should use and XY Scatter ...Simple Timezone question
One of our executive requested turn off or standardized the time zones for
one of shared calendar. He wants people who's sharing this calender to have
the same timezone so that they don't get confused. My questions are;
1. If he wants to standardized the time zones on specific shared calendar on
the Exchange server. Is this possible?
2. How does local timezone setting and Outlook timezone setting affect the
Exchange server? When you compose anything through Outlook, what timezone the
3. He cannot believe that we are the only company with people sharing a
calendar ...Problem in message tracking center
when i use message tracking center to search some e-mail in our exchange
2003 server,i find that some e-mail cann't to be in the search result.For
example,I sent 3 email to my stuff,and he received all. Then i tracked them
in the message tracking center ,only the first email could be tracked.
Thanks for ang reply!
I have an application that saves some configuration data
in the registry system (under
HKEY_CURRENT_USER\MyApp\ConfData) of the currently logged
on user. This way, every user who runs this app will have
his own configuration data.
When a user runs for the first time this app, the 'MyApp'
registry key will be created along with all its subkeys.
Now suppose we have 3 users and all of them have already
used the app. We will then have the 'MyApp' subtree
created for these 3 users.
What I want to know is that when the PC admin wants to
uninstall the app, how...Business Contact Manager's contact question?
Why isn't there any link between Outlook's Contact and BCM's Business
Contact? Outlook's Contact is more detailed information I'd liked to use but
BCM's Business Contact have cool features e.g. report, so why don't MS
integrate them in same one?
...Complex install question
I have a complex install to do and wanted to run a couple points past you
clever people. :)
What they have:
-2 Exchange servers
-1 SQL server
They want to have the CRM installed on the SQL server and the CRM exchange
router on both exchange servers (different sites + domains) and have access
to CRM from both sites/domains.
Is this possible?? what heads up can you guys give me?
Any ideas appreciated.
"Nathan Warner" wrote:
> Hi all,
> I have a complex install to do and wanted to run a couple points...an Embarassing question..
I am a 26 year old who has heard a lot about balancing accounts but have never bothered to balance my accounts so far. I am coming to my senses now and trying get my act together. I did view the video in M2003 about balancing and very much understand what it takes to balance my account.
But, when I am trying balance one of my checking accounts I am going nuts. I downloaded a statement from my bank, 'Accepted' all the transactions and M2003 asked me if all the transactions have to be marked 'Reconciled' and I clicked OK. On the left hand side I see the date when I downloa...Tracking of Birthdays in CONTACTS
In my contacts, I also key in their birthdays.
How to make Microsoft Outlook tracks and alert me of Contacts' birthdays?
outlook should create the appointments when you save the contact. if it
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Outlook Tips: http://www.outlook-tips.net/
Outlook &am...Newbie e-mail question
I'm new to this site and would appreciate some formatting help.
I created a new Word doc and copied and pasted some graphics and some
simple text boxes in to it. The graphics and text boxes were created
in Powerpoint by someone else. Looks fine on my screen.
Before sending it out via e-mail to an Outlook e-mail group I have, I
first sent myself a test message to see what it would look like on the
receiving end. It looks a mess! The text boxes are all over the
place, as is the text that is not in a box. Also, everything slide
over to the left hand margin a little bit, so the e...can I track IRA contributions?
I have several mutual fund accounts set up as retirement accounts, and
periodically buy shares in them as a monthly IRA contribution from my
checking account. Is there any way I can get a report at the end of the year
of all my IRA contributions for the previous year? You would think that by
running Reports->Taxes->Tax Related Transactions that they would show up, but
no such luck.
The category of each transaction in my checking account is Buy Investment/CD
which generates an activity of "Buy" in the investment transactions of the
mutual fund account.
I'm still on ...Microsoft Home Office and Student 2007 Trial Expiration notice
Popup notifying of expiration of Microsoft Home Office and Student 2007 Trial
has begun appearing whenever I want to use Excel files. Says I need to
convert to the full product. Trial period of 30-60 days is over, however,
I've had this program installed for ~ 2 yrs. w/o any problems at all. I
received a Word doc yesterday that I'm suspicious of....may have caused my
problems. Popup says that I have to enter 25 character code...I went through
this process once ~ 2 yrs ago. Please help a computer illiterate........
Just enter the key you received when yo...the questions part 6
1- Changing Admin group name in the production exchange server can make any
trouble ... if yes then please tell me the solution
2-How can we calculate the size of the mailbox store.
3-I found ADC, Site replication service and Exchange migration wizard
confusing … it seems like these tools does the same task … any comments why
they are different then ????
4-Can ADMT migrate clients form Unix and Novell GroupWise?
"Feelings" <Feelings@discussions.microsoft.com> wrote i...Activating my trial version of the Office Home & Student
I have never had this much trouble-it has taken all day off and on and still
no joy! I downloaded it, followed all the screen directions, even entering my
key. It says it's downloaded, but it won't kick in. I have tried all the
suggestions...even uninstalling and re-downloading twice. Ran the diagnosis,
and it came up with somethingabout a file that I "chose" not to download. It
tells me to get into the trust center, change a setting or two--and wait a
week! What's up with that noise? Can someone help me with this issue..need
that Word for studying. Thanks, and Ha...tracking total portfolio value
How do you track the total value of a portfolio or investment account over
time, on a daily basis? I want to be able to get a line chart of my
portfolio value. I have dug through all of the reports and tried to create
custom ones, but all I have been able to get is a line chart of monthly
values, not daily. I know that the daily total is stored, because on the
investing home page it shows the total value for 30 days ago. For instance,
today it is showing the value for 7/28/07.