Fixed multi-color background!
Can anyone help with this:
I need to be able to highlight my chart background as (in
rows from top to bottom):
Red, Yellow, Green, Yellow, and Red. So I can have my
Line chart run through it. I have only one data series
(values) that run on 16 columns. I've tried to hilite it,
but Excel will only hilite the entire background (plot
area) at once.
Any help is highly appreciated.
The multiple coloured background can be created by using a dummy
dataseries. For your chart you would use a stacked column.
Have a look a the technique shown by Jon in his example.
http://peltie...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...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,
...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?
...Text color in Combo box
I have a combo box - "Yes" and "No".
Is there a code I could use to make the "Yes" a different color?
Message posted via AccessMonster.com
Not built into ACCESS. And I don't know of any third-party control that will
<MS ACCESS MVP>
"Uschi via AccessMonster.com" <u25116@uwe> wrote in message
>I have a combo box - "Yes" and "No".
> Is there a code I could use ...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!
...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...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 ...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.
is there any tool in MS Money to track home consumption of electricity,
water, gas etc.?
Nope. One way you can fake it is to enter the values in a predictable way in
the memo fields (Utilities : Electricity category entries with memo like,
say, "876 kWh") and then get the data from Excel with MoneyLink and then
parse out the data you entered previously in the memo fields. Ugly, I agree.
"Radomir Kurecka" <RadomirKurecka@discussions.microsoft.com> wrote in
> is there any tool in MS Mon...Color Separation Printing
I have a new dell computer with 2003 Publisher. On my old dell, I had 2002
Publisher and was able to print color separations. I have gone through the
help menus to try and resolve this problem with no success. Do you have any
What problem are you having?
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"BFM" <BFM@discussions.microsoft.com> wrote in message
>I have a new dell computer wit...tracking
how do I track other users info on my comp as the administrator?
...where can i get the Template Wizard with Data Tracking add in for.
i previously used exel 97 where i had a Template Wizard with Data Tracking
add in that i used for keeping track of invoices. i am now using exel 2003
and i cannot find the add in nor can i figure out how to set up the data
tracking for my new invoice template. can anyone tell me where i can find the
add in or if there is a different feature of exel 2003 that will allow me to
do the same thing?
This link should help.
Please keep all correspondence within the Grou...To track or not to Track email
We're just starting the move from Goldmine 6.5 into CRM 3.0. I've been
looking through the group for "best practice" ideas and have a couple
of questions re: email. We're intending to use CRM through Outlook
(online). We've given up trying to get Outlook 2007 to work and have
regressed to Outlook 2003.
I'm trying to determine whether we should track or not track email
using CRM's token system. All our mail - barring the limited spam -
that arrives is work-based. However, using Outlook I know that some
staff (e.g. sales) will be checking their pe...Tracking calendar responses for a meeting invite
I am unable to view the meeting responses that I had created using Outlook
2007 calendar, even though I receive the individual mail responses from the
Is there a way to view the status from the 'Tracking' tab of the original
meeting invite itself in the Calendar?
Do you OPEN each response? Where are you looking for the tracking data?
What do you see when you look there?
Do you have any rules that may be affecting the incoming response emails?
"Kums" <Kums@discussions.microso...Case ID v/s Email tracking token
When you create a case for a support email, by default the generated
case id is of the form CAS-number-suffix. When a support person replies
to the email, the CRM system automatically adds an email tracking token
to the subject line. This email tracking token is not the same as the
1. Why can't the email tracking token be the same as the case id? Won't
it make sense to use case id to track emails for a given support case?
2. Even if they are different, how can I disable automatic placement of
tracking token on the subject line? We do not wish to confuse th...Outlook Exchange Tracking Email requirements
What are the requirements for Outlook Tracking Feature to work
1)Email should be sent from POP3/exchange outlook profile.
2)Any formating preference required (html / rich text / plain text)
3)If exchange, does it limit to both the sender-recepient be on same email
4)If exchange, does it limit to both the sender-recepient be on same
5)Will this tracking work for a trusted forest scenario.
6)It seems that MAPIRecepient proporty also plays an important role.
You mean read and received tracking receipts?
Those can work in any environment. There are man...Query re correspondence tracking
We are a small UK company who are investigating investing in Microsoft CRM,
after finally given up trying to keep an MS Access database of our contacts
and correspondence. I am currently trying to see whether it meets our needs
as a company, and must admit that I am so far impressed.
However there is one task which I would need a CRM to do which I cannot
quite see whether Microsoft CRM could cope with. With our existing Access
database, we allocated correspondence IDs to different mailshots, and then
linked these Correspondence ID with customers as and when we mailed them.
Thus we cou...TRACKING
When I use the track option in Outlook, it shows the
delivered date as current date and the read date 3 months
prior to delivery date.
Delivery date will 10/17/2003 and Read date would be
Any thoughts on how to correct this?
...Clueless: Creating a "Score card" to track how many research harboring calls are made
Ok, so I�ve got this (write protected, so a linked workbook would b
better) excel workbook from work of car dealerships we call, whic
lists the following information:
Who did the call (Myself, Nancy, Karissa, or Marie, occasionall
Contact phone number
I want the gist of the formula to read:
For every make/model:
If there is a dealership name present (That does not read �N
Participating Dlr�,�N/D� or a blank (null) then count that row as a �1
to be totaled with all other make/model combos later, displayed by wh
shop...message tracking #8
how to enable it in 5.5?
> how to enable it in 5.5?
it has to be enabled at the Information Store Site Configuration, the MTA,
and the IMS...at the SA, you tell the system how long to keep the files...
"Dooma" <Sayemail@example.com> wrote in message
> how to enable it in 5.5?