pie chart colors
I have a pie chart in a report that gives a percent of late reports per
manager per month.
I want the late percentage to show red and the ontime to show green.
The problem is, if it is 100% late or 100% ontime it always shows as green.
How can I fix this???
...MS Outlook 2007
I am running MS Outlook 2007 on a Vista home lap top. When trying to delete
files (or folders) in the Deleted Items folder, I get a message that "the
Folder is full" and the items remain. I "right click" on Deleted Items,
select "Empty 'Deleted Items' Folder", and I get the usueal warning msg that
states "Are you sure you want to permanently delete all the items and
subfolders from the 'Deleted Items' folder?" I click on "Yes". I then get a
second warning msg that says "The folder is full."
The ite...can't create a simple Line Chart
Several of us around the store have tried,,, and we just can't create a
simple Line Chart showing the growth of Sales from 1973 up to 2008. It seems
this would be so simple. I have the Excel Spreadsheet open with Column A as
"YEAR" and Column B as "SALES". I follow just as the instructions say,
highlighting the columns and inserting them in the Chart Wizard, but it just
doesn't display like it supposed to. I manually created what I'm looking for
using www.barchart.be, but I paid money to have this Excel software on my pc;
I wanna use it! Any help woul...MS Office 97 to MS Office 2007
I have been running Office 97 pro on Windows XP because I do not want
to loose the shortcut bar that came with 97.
Thing is that I have been thinking about installing the 2007 version
of Office that I have had but never installed yet for above reasons.
Question is can I install the 2007 version over the 97 version and
have it update the programs but keep the shortcut bar??
I know there are probably other shortcut bars or whatever out there
but as I asked I would rather keep the 97 one if possible.
Microsoft has several Knowledge Base articles on running multiple...Exchange 2003 Require a /3GB Switch with More Than 1 Gig RAM
Does Exchange 2003 require the /3GB Switch if you are
running Exchange 2003 on Windows Server 2003 Standard
Edition. I know for Exchange 2000 they said you needed
the switch if you are running Advanced or Datacenter but
not Server. Just wondering what they recommend for 2003.
291988 A Description of the 4 GB RAM Tuning Feature and the Physical Address
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup
"Kevin&quo...Use of MS Dynamics CRM in Utility Billing
I was wondering if we can easily use Microsoft Dynamics CRM 3.0 for 'Utility
Billing System and Print Presentment'. This also involves use of handheld
devices for reading meters and bill presentment.
In case you know about a better solution for this requirement, please share
that with me.
Cell: 0060 17331 4676 | email: IfThenElseEndIf@msn.com |
That depends on what you mean by "easily" ;-)
CRM out of the box will provide a great, flexible platform to quickly
develop a robust business solution. Fro...Totals in the data table but not in the graph / chart
I am graphing data that consists of 4 parts and over 5 years. I'm using a
stacked bar or an area chart and I do not want the totals to be charted. I
do however, want the totals (both by the year and the 4 parts) or across the
bottom and to the far right of the data table. I've chosen to have the data
table under the graph. I can easily put the totals into excel but then it
graphs the totals (which doubles everything). If I do not include the total
when I choose the graph the graph simply leaves them out with no space to add
Graph the total, hide t...Creating a Separate Chart for Each Row of Data
I need to create 150 similar charts for 150 separate rows of data contained
in an Excel 2003 spreadsheet. I am not an accomplished Macro author. Any
bright ideas out there?
Need a bit more info. Can you post a sample of the data you have including
column headers etc?
What sort of chart do you want?
Do you need to be able to view all or multiple charts simultaneously. Under
some circumstances using AutoFilter allows you to create just one chart and
it becomes dynamic based on the AutoFilter setting.
If AutoFilter option used, do you have a column with unique values or titles
that wou...Difference between MS EPM and MS Projects
What is the difference between MS EPM and MS projects
Is it just project server and sharepoint added to MS projects together
called MS EPM?
Yes. EPM is Enterprise Project Management. Microsoft's solution is Project
Professional plus Project Server which in turn uses SharePoint technology.
Microsoft MVP for Project - http://www.project-systems.co.nz
Author of the only book on Project VBA, see: http://www.projectvbabook.com
"Project Mgt Noob" <Project Mgt Noob @discussions.microsoft.com> wrote in
message news:A565E3DF-A7FC-4D2A-B2F1...MS Exange connection
It deals with Outlook 2003, running under Win XP home:
A friend has two ISPs, one with standard POP and SMTP servers, no problem
The second is a remote MS Exchange server. He connects to both via Internet
using ADSL connection.
Question: how to configure the Exchange server connection such that it
remembers his ID and PW? I could not find anything under just about any
thinkable tab in Outlook, email accounts, etc.
Any help will be greatly appreciated.
...How do I do word count in MS Publisher?
Publisher doesn't have a word count; the work-around wound be manually count
the words or you could try copy the text and paste into Word.
Don - Publisher 2000�
"Mike Finn" <Mike Finn@discussions.microsoft.com> wrote in message
Why not just do a "Edit Story in Microsoft Word" instead of copy and paste?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Don Schmidt" <Don Engineer@PNB.Retired_...Is there a way to extract files from the Off line files cache
I have a laptop that used to be a member of a SBS 2003 domain and was
utilizing folder redirection of My Documents. The laptop was never
reconfigured to remove it from the domain and the user continued to use the
Since that time (about a year ago), the computer and user were removed from
the SBS domain.
So far so good, the user on the laptop was happy..
Today, the laptop was worked on and was removed from the domain. Now, the
question is, where are the files that used to be in My documents? I
beleive they are cached in the Offline files folder (C:\wind...MS CRM Certification question
I have a question regarding the CRM certification? What, if any,
certifications are there available with MS CRM? Is there anything like CRM
Have I earned any certification if I passed the Applications Professional
Kuba Skalbania [MCAD]
...Drawing Objects disappear from charts
My question has to do with Excel 2003 Home Basic edition.
After adding a text box or lines to a chart, the objects
disappear when I click outside the chart. They reappear
when I then click on the chart. Also, if I move the chart,
the objects appear on the worksheet. How do I "attach"
the objects to the chart without Grouping them? Grouping
them works, but seems cumborsome to use if I want to
make changes to the format or data series.
On Feb 19, 3:22 pm, Dave <D...@discussions.microsoft.com> wrote:
> My question has to do with Excel 2003 Home Basic edition.
>...MS Money 2005 Basics
I am new to MS Money after many years with Quicken. Money help
offline and online, seems woefully short of detailed explanations o
user scenarios. . Searching help for "Epay" yields nothing. Ca
someone either direct me to a better help area or answer this
In Bills what is the difference between Epay, APay, and Direct debit
I see Apay is how i use the bill pay service of my bank. Is direc
debit just my manual entry? What then is Epay? What might "Other
payment type then be used for?
The difference between them is this
Epay is for electronic bill pay. You must have Bi...Sent items downloading problem in MS office outlook 2007
In my client pc's i have configured the Microsoft office outlook
2007 after the configuration inbox mails are visible in inbox but
sent items and other folders are not getting downloaded, my mail
server is squirrel mail ,so please let me know the reason .
POP3 or IMAP?
"xpmate" <firstname.lastname@example.org> wrote in message
> Hi all,
> In my client pc's i have configured the Microsoft office outlook
> 2007 after the configuration inbox mails are visible in in...MS Access
Why doesn't MS support MS Access for Macintosh? Since I work in an
educational environment that's mostly PC with MS Office begin the main
suite, it would only be logical that since the PC version of MS Office
contains MS Access for database entry, the Mac version of MS Office would
also have MS Access.
In article <BE09D66D.5FB8email@example.com>,
Red Claw <firstname.lastname@example.org> wrote:
> Why doesn't MS support MS Access for Macintosh? Since I work in an
> educational environment that's mostly PC with MS Office begin the main
> suite, it would only ...How to omit data in a chart when there are error values?
I've created a chart based on data who's values are variable. In certain
cases the data on one end can show error values (#DIV0!, #NUM, etc..). In
those cases the chart sees them as zero values.
Is there a way to automatically omit these values from the chart without
manually changing the series range?
You can test for an error:
This way you get the #N/A error, which is not such a problem for a chart.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and...Restarting MS Money with a "correction" switch
This is a multi-part message in MIME format.
I currently use version 10 - 2002 Deluxe, and I need to startup MS Money =
with a correction switch that I hope will correct some problems that I =
been having, but I can't seem to locate the post that talks about doing =
this. Is it "msmoney.exe /s"?
(if replying, replace nospam with rpottharst)
c...Out of office #3
I am enable to access the option of "out of office
When I go on the HELP on OUTLOOK for this option...this
is what it tells me:
Automatically reply to incoming messages while out of the
On the Tools menu, click Out of Office Assistant.
Click I am currently Out of the Office.
In the AutoReply only once to each sender with the
following text box, type the message you want to send to
others while you are out.
For information about how to use rules with the Out of
Office Assistant, click
Well when I go to my TOOLS on my outlook, the "Out of
Office Ass...Starting MS Outlook on startup
How can I start Outlook on startup (XP) and keep it running in the back?
>How can I start Outlook on startup (XP) and keep it
running in the back?
All you need to do is move the Outlook program icon to the
startup group in XP.
>How can I start Outlook on startup (XP) and keep it
running in the back?
>Double click My Computer, go into the C:\Documents and
Place an Outlook shortcut into this folder and it will
automatically startup when...Alternative to Ms sql server 2005 express edition
Our server hosting providers are saying that our web site is running slow
because we are using ms sql server 2005 express edition which is a free
edition and had only a capacity of handling up to 4 GB data.
And our database which we are currently using is now having more than 4.5 GB.
Hence they recommended us to go for a paid one that is specialized edition
workgroup and gave us the following link
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx to go through the
The hosting providers says that it will be around 4500 rupees per month for
...MS Word Problem
following problem: in a MFC MDI application one also shall
Being displayed Word97 document. And but not in an external program
but as a one prayed OLE object. I have managed this.
The following problem lets itself be seen now: if I maximize/reduce the main
the visible range of the Word document shall adapt
the visible doesn't become however if I maximize the object frame of the OLE
Range of the document changed but Word zoom lens the document.
To this the one prayed window is placed so for this these force
are no longer visible.
I can ...MS Money Planner file
I have a problem in MS Money 2004.
Each time I open money I get the following error:
"A file needed to run the Planner is either missing or corrupted. To resolve
this problem, re-install money and then re open your money file".
I have tried doing this but still keep getting the same error.
Can anyone please advise?
Thanks and a Happy New Year to all you kind souls out there.
That seems to work for me.
Thanks for taking the time and trouble to reply. Much appreciated.
Hope you have a happy & prosperous New Year.
"Glyn Simpso...excel charts in motion?
Is there a way to link and export several charts together into a single
gif or .mpg file so that they could play in rapid progression, showing
change in the shape/magnitude of a curve in the chart? I have heard
that you can export a single chart as a .gif. I need to create a
"movie" showing the development of a data curve, which start nearly
flat, and over time becomes nearly bell shaped. Any ideas?
Message posted from http://www.ExcelForum.com/
One possibility might be to paste them from Excel into a graphics program
that supports animated gif files. Save from ther...