Stacked Column Charts #2
I am trying to create a stacked column chart with the following data.
NR RM Indirects
2006 AOP 100 100 50
2006 Actual 104 102 33
2007 AOP 100 100 50
2007 Actua l60 169 15
2008 AOP 125 100 100
2008 Actual 148 77 161
2009 AOP 100 100 100
2009 Actual 0 0 0
I would like for the x axis to be years 2006-2008 and the y axis to
represent the amounts. My issue is that I need the 2006 AOP and the 2006
Actual to be two stacked columns in the x axis 2006 label (side by side).
AOP and Actual need to be side by side for each year. There should only be a
gap between years.
...Free/busy problem #2
I have an exchange 5.5 server, which for various reasons, the schedule+
free/busy folders are gone/corrupted/not working.
I set up a new exchange 2003 server in co-exist mode, and moved some
mailboxes over to it. Now, users on the exch2003 still cannot see free/busy
info for each other.
I checked and there is a free/busy system folder on the new exch2003 server,
but I think it's still trying to get the info from the old screwed up server.
Is there a way to get the 2003 server to be the "main" one for schedule+ F/B?
Define "co-exist mode" since that is a nonstand...Money locks up #2
Whenever I try and open Money, nothing happens, everytime I have to close the
program because it is not responding, I have tried reinstalling, but nothing
works. Advice would be helpful.
In microsoft.public.money, mattmtv wrote:
>Whenever I try and open Money, nothing happens, everytime I have to close the
>program because it is not responding, I have tried reinstalling, but nothing
>works. Advice would be helpful.
Try opening Money by double-clicking on the sample.mny in your Money
install folder. If that works, suspect a problem with your Money
file rather than the ...CRM upgrade from 1.2 to 3.0 with SQL instance fails
The Microsoft CRM 3.0 server does not upgrade my basic CRM 1.2 server. When
it is checking the server requirements, I get a couple of errors like
"MachineName value SQL1\CRM is invalid" and "The SQL Server 'SQL1\CRM' is
unavailable". I am hosting the CRM databases on a seperate SQL 2000
instance. I can validate that the CRM 1.2 server has no problems accessing
the database server because everything is working.
Here is what the help says when I click on the error:
Named Instance Microsoft SQL Server Found
Setup has found that you are trying to ...i m using one Pst One Email-id but 2 system mail are coming 2 copy
i m using Microsoft Outlook 2003 . using one E-mail ID and one PST file
but I m using in 2 different Systems . mail are coming 2 copy what is
i want one copy only
Saravanakumar, you wrote on Mon, 19 Mar 2007 02:05:15 -0700:
> i m using Microsoft Outlook 2003 . using one E-mail ID and one PST
> file but I m using in 2 different Systems . mail are coming 2 copy
> what is solution. i want one copy only
Uncheck the option "Leave a copy on server" (or similiar):
Tools | E-Mail-Accounts | Existing E-Mail-Accounts
There select the email account, click on "...HELP! Seeking Instructions to Create Report of POS (NOT RMS) Discounts Applied #2
We need to run monthly reports to determine how many of our different
Discounts are claimed/used and the proceeds not tendered. We have offered a
number of discounts to customers and employees as incentives and cannot find
a method to track how each discount is applied.
The built-in Discounted Sales report in POS 2.0 lists only the resulting
Sale Price; we seek to have the report sorted by PresetDiscount type but the
Advanced Report Filter dialog does not list Discount in the Field dropdown
box and we can't locate the table in which transactions that have the Preset
Discount are appl...Excel 97 #2
I am trying to do the following in Excel and not succeeding - any chanc
of some help.
I have two arrays of date and time. Arrays are different lengths.
want to compare one element of array A to all elements of array B, an
do this for all elements of array A.
Say there are n elements in array A.
A, B, C and D are all arrays
For i = 0 to n-1
C = B - A(i) : create a new array C
C = Abs(C) : convert values of C to absolute value e.g. ABS(-2.5)
Position = min_pos(C) : find array position of smallest element o
Min_difference = C(position)
D(i) = Min_difference
Cheer...updated to 11.2.3 but only entourage notes shows up in .mac sync menu
so I would assume this means I can only sync notes. What about adresses
and calendars? Any one have this issue? Any one solve it? Thanks in
Entourage's addresses and calendar entries can be shared with Address Book
and iCal, so you can keep using you traditional .mac synchronisation through
the System Preferences for that.
On 16.03.06 5:12, in article
> so I would assume this means I can only sync notes. What about adresses
> and calendars? Any one have this...Cash Drawer will not open #2
We are configuring RMS for the first time and are running into some trouble
with the cash drawer. I've got an Epson Tm-T88IV (USB) printing runing on
the Epson OPOS ADK, as well as POS-X Xc16z cashdrawer. The drawer pops in
ADK, but for some reason nothing happens in RMS. I have the tender type set
to pop the drawer, and the devices are configured as OPOS. Any ideas?
This is a multi-part message in MIME format.
The logical device name must be the sa...missing or broken reference to the file "mscomct2.ocx" version 2.0
MS Access 2007 - Windows 7
We have a small Access database on a small server accessed through work
We have recently changed our infastructure to a Windows 7 / Office 2007
platform. 2 PCs can access and utilize the database succesfully through
Windows 7 / Office 2007. However when we try to open the database from other
machines, we get an error message that "Your MS database or project
contains a missing or broken reference to the file "mscomct2.ocx" version
2.0". To ensure that your database or project works properly, you must fix
this refere...Printing labels #2
I have created a holiday gift label in Publisher. I do not however need to print a full page for each relative. Can anyone help direct how to print a specific number of labels as opposed to a full page.
What version of Publisher are you using???
This is the ugly way of doing it.
I use Publisher 2000.
I take a piece of 8�"x11" (in A4 country, use A4) and some Scotch Temp tape
and cover the labels I don't need.
Vancouver, USA - One of the great cities in one of the 45+ countries in
"Ed Heff" <firstname.lastname@example.org> wrote i...Registration Issues #2
I reinstalled my copy of Office from the disc after a hard-drive
replacement was done at my local Apple store, then left for a study
abroad program. I forgot to copy my product keys and had to have them
sent to me by my family, but the Test Drive had already expired. Now,
I can't find any way to input my product keys and the program is
locked! Do I have to get them to mail the cd halfway around the world
or is there a way I can still register the install I have on here?
I'm not really clear on your situation, but if I understand correctly you've
reinstalled Office (2004?) without...Consuming Axis 1.2 Service with .net vb client
I have a problem consuming a webservice using a .net client written in vb.
I used a wsdl to generate the proxy class and it worked like a charm.
Sending requests to the service is not a problem. Even complex custom types
are received and processed by the service.
When it comes to receive the response from the service, complex types
produce an error like:
Error in xml document (1,130), which occurs in
String encodingStyle, XmlDeserializationEvents events)
bei System.Xml.Serialization.XmlSerializer.Deserialize...Date problem #2
I am trying to add a date function to my spreadsheet. I want it to
display the date that a certain value was entered. So far, all attempts
have resulted in a date that reupdates everytime I reopen excel. Is
there a function that will insert current date and make it static?
Your post has an April 6 date on it and today is only April 2. Did you check
your PC clock 1st? That may fix your problem.
"Drew Reed" <email@example.com> wrote in message
> I am trying to add a date function to my spreadsheet. I want it ...VB.NET 2003 and Crystal Reports 9.2.3
When I add a report designed under Crystal Reports 9.2.3 into my VB.NET
project I get the error message "Cannot find custom tool
'CrystalDecisions.VSDesigner.CodeGen.ReportCodeGenerator' on this
Does anybody know how to fix this problem?
Change "custom tool" from
...Nested formular to give a word answer based on 2 cells
I have a s/s which I want to produce a statement based on 2 cells
G170 is a cell that contails a sum (if cells above are filled it it will add
I170 contains a cost
if G170 & i170 are blank then do nothing
If G170 is greater than 0 and I170 is greater than 0 then again do nothing
but if G170 is greater than 0 and I170 is = < 0 then "No Charge Made"
Can anyone help all I get is FALSE
I have tried =if(g170<=0, and (i170=<0,No Charge made",""))
=IF(AND(G170="",I170=""),"",IF(AND(G170>0,I170...On change event #2
I have two fields, one numeric and another datetime.
I would like the datetime field to be updated automatically whenever
the number field is populated by a number. If later on that number
changes, I don't want the datetime field to be updated accordingly.
Can someone guide me on how to create this ?
Thanks in advance,
...converting from Quicken 2004 #2
I'm sure this has been asked before, but I did do a search on Quicken in
this group and I didn't find it. So please forgive me if I'm rehashing
I just downloaded Money 2004 and tried converting my Quicken 2004 file and
it's not converting. Does the Money converter not yet convert a Q2004 file?
what are my options?
In microsoft.public.money, Bruce wrote:
>I'm sure this has been asked before, but I did do a search on Quicken in
>this group and I didn't find it. So please forgive me if I'm rehashing
>something....2 (or More) MSCRM's talking to each other
Wondering whether anyone has done any work on linking up
two or more different instances of MSCRM.
Parent comapny has the master MSCRM.
Subsidaries have their own MSCRM instances.
The Subsidary MSCRM's need to send their data to the
Master one regularly.
It seems possible based on the availability of the API's
but I would appreciate any feedback on this.
If we assume the company and subs are all part of a big wide area network
and are all in one active directory tree then yes it would be possible but
the level of code required would be so great you might as w...Exchange Server 5.5 Help #2
Is there a way to set out of office reply on the email server rather
than at the client's machine? because when the client's machine is
off, no reply will be sent. I am using exchange server 5.5 with
internet mail connector.
firstname.lastname@example.org (Leo) wrote:
>Is there a way to set out of office reply on the email server rather
>than at the client's machine? because when the client's machine is
>off, no reply will be sent. I am using exchange server 5.5 with
>internet mail connector.
Out Of Office messages are c...Circular logging question #2
If I create a new store with circular logging enabled, do I still need
to restart the information store service?
Circular logging is activated at the Storage Group level. The GUI will
prompt you to take all DBs offline and then online.
Circular should never be used on back end servers.
"justsimplequestions" <email@example.com> wrote in message
> If I create a new store with circular logging enabled, do I still need
> to restart the information store service?
> Thank yo...Disclaimer Message #2
I am running Exchange 2k3 with sp2.
I followed the instructions in
http://support.microsoft.com/default.aspx?scid=kb;en-us;317680 to create a
disclaimer to outgoing emails using vb script.
I am able to customize the message, but I can't put any different styles to
it. I would like to change the font type, size and color but it won't seem to
take any commands.
I'm definitely not an html coder so I've been trying to figure out how to
make it work. I have created the message I want, and it works correctly when
I put it into html checkers. But when I put it in the vbs, the...Excel password #2
My app uses the Excel COM server to load spreadsheets and read/write data in
it. I am having a hard time finding how I would know if a spreadsheet is
password protected before having tried to load it. The COM exception which
is raised when a password protected spreadsheet is loaded, cannot be
reliably assumed to be that due to a missing password, because it is a
general COM exception.
Any help would be greatly appreciated.
This message is provided "AS IS" with no warranties, and confers no rights.
Any opinions or policies stat...Is it possible #2
So I have a spreadsheet that has in each cell a code that looks like the
following "NYL5". What I want to do is take the 4th character in this
code with is always number and add them all together in a column and
then calculate the average. Is this possible at all? If so can you tell
carley465's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28085
View this thread: http://www.excelforum.com/showthread.php?threadid=475906
To get th...page size #2
Please help me with this. I cannot for the life of me get the right margin
to be at the 1/2 inch it is set to be. When I print the invoice that I
created, it is about an inch wide on the right. I have used the page
preview and moved margins and page size around, but to no avail. I am
stuck. Thanks in advance, Jeff
Please, no repeat posting on the same day.
First, if your data doesn't extend far enough to the right to reach the 1/2
inch margin, it will look like there is a larger margin. A few options - in
the spreadsheet widen a few columns of the print area. On th...