show another column when hovering on a point in a chart
Is it possible to show another column when you hover on a point?
I have 3 columns, A, B, and C for a scatter plot
I have B and C as x and y coordinates of a point,
and I'd like to have Excel show A when I hover on the point.
...Change of recipient/sender display name
Environment :- Windows 2003 x64 with exchange 2007 (All in one role)
Outlook client :- 2003, 2007
We have created a list of mail contacts (which under GAL) in exchange
2007, these mail contacts are associates with external email address,
each of contact has a naming standard for display name, for example,
display name is HD Finance Manager, external email address is
I want to configure outlook client to show the display name according
to mail contacts whenever the email address is match to mail contacts
list (GAL), for example, an email sent from the email a...Can the column index in a cell address be made variable?
To refer to a cell with a variable row number, we can just code it as,
Dim i As Interger
Range("A" & i).Select
To refer to a cell with a variable column index, it seems not that easy
because the column
index must be explicitly specified in a cell address. So, if I want to
go to the j th column on the 2nd row or j columns to the right of cell
AA3, is there a quick and easy way to do it? Thank you in advance.
You may be able to use R1C1 terminology, but you'll need to get someone else
to help from here.
"cyberdude" <honc...Not allow entering repeated references in a column
If you don�t mind ... I will send it :) .
As I don�t know your e-mail, I will give mine, which is
Just send your e-mail to my e-mail box and I will send the file.
ritinha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1566
View this thread: http://www.excelforum.com/showthread.php?threadid=27195
We get this NDR error when someone sends to a particular address:
550 Only 1 recipients accepted with null sender address
Again, the emails are sent using Outlook to a listing in our GAL for the
Custom Recipient. I have checked the outgoing messages and they do contain
a sender address.
Have you contacted the recipient's admin folk on this?
> We get this NDR error when someone sends to a particular address:
> 550 Only 1 recipients accepted with null sender address
> Again, the emails are sent using Out...chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the
number of the column I want to chart (these numbers are listed as labels in
I can't figure out how to translate the number in S4 into the corresponding
column letter. For example, if S4 contains "3", the chart title should be
I think working with absolute references, R1C1, might be easier here, but
somehow what I've tried, didn't work (the entire spreadsheet is based on
relative addresses (A1).
in a cell (Z100) put
Change G2 to whatev...Custom Item Movement Report
Anyone out there have a custom item movement report and item movement
history report that includes extended description that they would be willing
That was a pretty tricky request but I was able to make the change.
Download the reports here:
If you cannot download from there shoort me an email and I will send
over. Check out our RMS add-ons website in exchange..
New West Technologies
Can you do one with "Transferred To"...Outlook offline reports not available
I have setup most of my CRM 4 users with the Outlook client, which seems to
work considerably better than that in CRM 3. However, when the clients are
traveling and unable to attach to the Internet, the reports are not
available. Is there any way to make the CRM reports available offline. The
SQL database is loaded on each of the user PCs and everything else seems to
be working just fine. Any assistance will be appreciated.
It is working on our end ok.
I would try the following:
1. Setup a test client with a CRM Administrator login and install the 4.0
CRM Outlook ...IWAN & IUSR bei Crystal Reports? *help*
my problem is that i can see the crystal reports, but when i open one i get
"more information is needed".
But till yesterday i could open reports!!
Now after some search i see that i have no IUSR_servane and no
IWAM_servername. how could this happen?
My system is AD, SQL, CRM and each of them is one a seperate 2003 server.
Please let me know if you have any suggestions.
sound strange with the IWAN and IUSR.
I offten have this problem. There are a techknowledge article with 13
resoluti...Passing a variable as a parameter value instead of a literal string to a child report?
In the Navigation section (Jump to URL), I have the following:
This works as designed - a new window pops up with the "My Report"
report and the StartDate and FinishDate of 01/01/2009 and 12/31/2010
are passed respectively.
But what is the syntax for changing the "01/01/2009" and "12/31/2010"
to variables that point to the StartDate and FinishDate parameters of
the PAR...Z Report shows zeros for an entire shift
How do I correct the problem described above? All receipts are printed
correctly, and all transactions seem to be successful. However, the Z report
that is run at the end of the shift prints all zeros? Any ideas???
I am having the same problem. All the transactions are successfull and I can
see the sale amounts and etc at crstal reports but all the z, zz and x
reports print "$0.00" amount. Does anyone know how to solve this problem?
> How do I correct the problem described above? All receipts are printed
> correctly, and all transactions seem t...Print Report "Bold" Font Category Name Problems
When I print income/expense reports in MS Money 2006 the category names do
not print in bold, making them very difficult to read since they end up as
the same font as the sub categories. On the screen, category names are
bolded. Does anyone know how to fix this print problem?
...open/save dialog title broken
The title bar of any Office 2003 program's open/save dialog has just a
single letter. Any ideas what's broken?
...KnowledgeBase Title Chage to Article
My company has a product called "KnowledgeBase" which obviously causes
confusion with the CRM "Knowledge Base" articles. Can anyone tell me
where I can change the title of "KnowledgeBase" to something like
"Article" within CRM?
...Z Report Customer Count vs Hourly Sales
My Z report shows customer count of 380 and hourly sales total of 384. Why
the difference? This happens all the time.
Your glass is:
Half-Empty : Do folks at register forget to ask "Is there anything else I
can help you with?"
Half-Full: Your impulse items at POS are working -- better late than never!
> My Z report shows customer count of 380 and hourly sales total of
> 384. Why the difference? This happens all the time.
OlyBikes Locally-Owned B...Reporting Services not installed
I have installed crm and reporting services but when I go into a report,
display it and then hit print I get an popup box saying....
"Do you want to install this software?
Name: Microsoft SQL Server Reporting Services"
Can anyone help please
There's an ActiveX control each client machine needs in order to print SQL
Reports from CRM. It's a one-time 5-second install.
Matt Wittemann, CRM MVP
> Hi all,
> I have installed crm and reporting services but when I go into a report,
...MVP PLESE; Report Manager
I did all required in installation and when the Report Manager comes up
I get no options either under "view or scenario", All I see is "none".
No selection in the drop down for any of the 6 out of 20 columns I want
Is my Report Manager corrupted? I just d/l it today from the MS site.
Running Excel 2002.
It's so easy in MS Works.
...How to display Total Item Quantity on receipt and Status bar
I would like to print a total Quantity of items purchased on receipt and the
I found a way of displaying them but the problem is that we use tag along
items for alcohol tax . This tax differs based on alcohol content and size,
example a 6 pk of beer has $0.20 tax plus sales tax, a 750 Ml a bottle of
wine has $0.116 tax .
If i ring up a 6pk or beer this would show up as 2 lines(line one name and
price for beer , line two alcohol tax tag along item) on POS screen and the
Total items and total QTY count shows as 2 when in reality only 1 item was
This gets even more conf...Column comparing
I am trying to compare 2 columns of numbers so that I can identify and
delete numbers no longer required. Can anyone help me find a formula for
Check your earlier post.
Dave T wrote:
> I am trying to compare 2 columns of numbers so that I can identify and
> delete numbers no longer required. Can anyone help me find a formula for
> this please?
> Many thanks
...Hyper link one column to another
I would like to have my columns hyper link one another.
For example: Click on B2 would take you to N2, and vice-versa. Click
on C2 would take you to O2... and so on through column j linked to V.
Is this possible without having to make the link for each cell?
This is a timesheet template and the columns b though J are the hours
and N through V are the text comments for those hours. When I copy the
template to a
new sheet, there will be no data in any column. I would like to be
able to enter an amount or formula (=end-start) for time spent and then
be able to click on that cell and hyperlin...Prevent Hidden Column data from being copied/pasted?
A student came up with a question that I haven't been able
to figure out yet in a recent Excel class.
They are hiding a column and protecting the worksheet in
the correct manner. They want to allow some users to
access and enter information in some cells. They do not
want the users to be able to copy and paste the
information from the hidden column. The question is how
can this be prevented?
For example, Column B is hidden. When they copy a range
such as A1:C10 and paste it to another worksheet, they are
getting the "hidden" data in Column B in B1:B10.
Any suggestions wou...Reporting in POS2009
I have installed pos2009 on XP machine and unable to get the standard reports that are included in the product to function properly. For example on the main screen of the managers view it shows me daily sales / top items / sales per cashier / etc.
When I go into reports to look at the report for daily sales it comes up totally blank - indicating no data to report. I have checked to make sure there are no filters applied.
All the reports behave the same way.
Otherwise pos2009 appears to be functioning normally.
Any troubleshooting tips would be appreciated.
EggHeadCafe - Software ..."Error on page" and error report on entity close
We have CRM 4.0 rollup 6 implemented from a CRM 3.0 upgrade about a month
ago. Recently, my users have been reporting an error report being generated
when they try to close (or save & close) any entity they have open. The
entity is closed (or saved and closed), and I have asked them not to send the
error report, but of course this needs to be resolved. I have noticed that
once the record is open, "error on page" will appear in the bottom left of
the dialog if you will receive the error report dialog, which doesn't happen
every time. Also, if I do an IIS...combining columns all the way down
I am trying to combine two columns of information in excel but th
concatenate function doesnt seem to work for it. It may just be m
ineptitude in excel but I just cant seem to figure this out.
I have 3 colums
Column A__________Column B___________Column C
But I cant seem to be able to make it so that column C has tree.jpg an
dog.gif and house.png
Is concatenate the wrong thing to use here? or am I making my formula
I have a total sheet that gets data from three different shift sheets (all
in the same workbook) for a monthly report. I have named ranges on each
shift sheet for each month's production data (S1M1, S1M2, S1M3, S2M1...)
where S1M1 =A2:AC147, S1M2 = A148:AC329, etc. The old formula
was:=SUMIF('SHIFT 1'!$L$1:$L$147,"BB",'SHIFT 1'!$T$1:$T$147). I'm stumped as
to what the new formula would be - how would I direct Excel to column L of
S1M1 to search for "BB", then add the contents of column T? The range
changes each month, and I tho...