Pivot Chart, line graph w/ multiple series
I have columns of cust, year, est sales, actual sales.
Customer is put in page area, year is put on category
axis. I can add est sales to data area and will have one
line. But when I add the actual sales to the data area,
it does not show as a line, but adds itself to the
category x axis. Am I missing something?
If you are adding the field directly on to the PivotChart, consider
using the associated PivotTable. Is the 'actual sales' column part of
the data field or one of the the row/column fields? Ensure it is a
Tushar Mehta, MS MVP -- Excel
ww...Printing multiple worksheets on one page #3
Is this possible. I need to print 4 worksheets on one large page and print
from the plotter. If not possible, any suggestions? Help . . .
> Is this possible. I need to print 4 worksheets on one large page and
> print from the plotter. If not possible, any suggestions? Help . . .
One way is to use MS-Word. Insert a 2x2 table in a Word document. In each
cell of the table, use either
Insert >> Object >> Create from file
Insert >> Object >> Create new >> Microsoft Excel Worksheet
If the ranges are smallish....
You could insert a new worksheet...Assign Multiple Credit Card to Customers
My client wants to assign multiple salesperson ids to their customers. Has
anyone had this request? Please let me know. Are there any third party
products that address this?
We used Extender to accomplish this..
How did you build the logic? Like if the commission will be split 50/50?
Please let me know. Thanks
> We used Extender to accomplish this..
...Counting with multiple criteria
Would be grateful if someone can help me with this
A B C D
1 CA03 ON CA03 OF
2 CA03 OF CA03 OF
3 CA03 ON CA03 TR
4 CA03 TR CA03 TR
5 CA05 OF CA04 OF
6 CA05 TR CA05 ON
7 CA04 OF CA05 TR
Note: Column A-B has the same header row, and so does C-D
I want to count in the range (A1:D7)
- How many CA03 and TR: [the result should be 3]
- How many CA03 and ON and OF: [the result should be 5]
Thanks in advance for your help.
Assuming your table is in A1:D8,
data in rows 2 to 8 (in A2:D8)
> ...question on multiple email domains
what options do I have to accomplish the following:
hosting email for 2 email domains on same exchange 2003 server (domainA and
domainB). DomainA and domainB represent different divisions of one company
but many users will be doing work for both divisions and therefore need to
have the 2 email addresses. Here is the critical part: when email sent to
say, rsmith@domainA is recevied by rsmith and rsmith replies, it must come
'from' rsmith@domainA, and when email is sent to rsmith@domainB and rsmith
replies it must come 'from' rsmith@domainB. This is because it is the same
...Search for a Credit Card number
I'm trying to put a new customer in our system and when I enter the credit
card number it's telling me that the card is already in the system. Is there
a way to search for a card number or possibly a script to find what customer
this card number is associated with? Any help or a point in the right
direction would be greatly appreciated. Thank you in advance.
What payment application and/or 3rd party application(s) are you using that
allow you to input a customer credit card number on the customer card? Why
would you be blocked from inputting a duplicate? If you could prov...Is there a way to delete multiple lines at the same time beside u.
Please let me know if there is other ways to delete multiple lines at the
same time without using the Ctl key. Thank you.
are the lines adjacent to one another? if so just drag down the row numbers
and then right mouse click & choose delete .. .if they're not adjacent and
you don't want to use the Ctrl key to select them, how are you going to
identify which rows you want to delete?
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"cherry" <firstname.lastname@example.org> wrote in message
news:4BD...RMS should have a search strategy for "date account opened"
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
you can do this with reports.
"samax" <s...Search engine in Outlook #2
When I click on Web Search in Outlook, it used to take me to Google, now
however, it takes me to Yahoo.com. I DON'T WANT YAHOO! I want Google.
Please advise, and thank you.
Where are you clicking this Web Search in Outlook? What version of Outlook?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After furious head scratching, Celticson asked:
| When I click on Web Search in Outlook, it used to take me to Google,
...Multiple Exchange Users
I need the users in the dl-ecm list to be able to send mail as 'ECM'
(Long name "Enterprise Change Management") (ECM@XXX.COM ?)
The desired effect is that members of this list can send mail that appears
to originate from the entity 'ECM' and not themselves. Replies therefore
will go to the list. This essentially allows for anonymity and the use of
the ECM account as an 'entity'.
The list is currently comprised of the following 5 users;
How would I achieve this goal with Exchange 2003 and AD 2003?
...Merging Multiple, but similar, Spreadsheets
I have about 1000 small spreadsheets. They each have the same
columns, but different rows of data - anywhere from 1 row to 250. An
idea how I can easily combine all of these into 1 spreadsheet?
Message posted from http://www.ExcelForum.com
Post back if you need more help
Regards Ron de Bruin
"mcman460 >" <<email@example.com> wrote in message news:firstname.lastname@example.org...
> I have about 1000 small spreadsheets. They eac...Asset Reference Data for Multiple Location Companies
I am looking for suggestions on where best to place custom reference data
for companies that have multiple locations. The same data is collected for
each location and it is specific to the individual location.
Our internal assesment suggests adding custom fields and tabs to the "more
addresses" section would be the easiest option.
This would require setting up a duplicate address for the Primary Company in
order to record it's site data.
We also considered using sub-accounts and adding a new option in the Service
group. As I interpret it, the Microsoft documentation sugge...Money 2003
I have a problem with downloading statements from my bank. If a =
downloaded deposit needs to be matched with multiple entries in the =
register as when depositing several items at once, I can manually match =
them up just fine. The problem is the next time I download, Money =
somehow does not realize the transaction has already been downloaded and =
I get another copy. At this point I am stuck since I can not re-match it =
and deleting the downloaded transaction just causes it to be downloaded =
again. Matching downloaded transactions with a single entry causes no =
problems. Any ideas on wha...Unable to Change Search Engine
I'm using IE8 with XP and when I try to change my search engine using
the following Microsoft's "Help" steps, my screen looks nothing like
what was suggested!
"To change the default search provider
Open Internet Explorer.
Click the arrow to the right of the search box.
Click Manage Search Providers.
Click the search provider you would like to set as the default, click
Set as default, and then click Close."
I have NO "arrow to the right of the search box" - all I see is the
search box followed by "Bing". I want to use Google....Email templates in Workflow engine
I am battling with using the template manager within CRM to create a email
template. example. I want for ever new case that gets assigned to send a
email to the client informing him/her who will be working on their case and
what their case number is.
I have created a template in CRM web front end, but in the template nowhere
does it specify were you will be sending the email to. When I create the
workflow there is also nowhere that I can specify where the email will be
Any help or direction will be appreciated
This is a strange "Feature" of MSCRM. You can either:
...Updating multiple linked workbooks
We have several workbooks which 1 gets data from other etc. is there anyway
to have a one step to update all at once
Not in the usual sense. Generally you can only update from one 'level' of
linked workbooks unless all are open.
What you can do is open all related workbooks and then use
File | Save Workspace
to quickly have access to all of those needed workbooks. See the Help topic
on Workspace for more information.
> We have several workbooks which 1 gets data from other etc. is there anyway
> to have a one step to update all at once
...Please, need help with multiple "if" conditions
This spreadsheet has 5 columns.
In Column B, "District," you input the number of a school district.
There are 20 districts, so these will between 1 and 20, inclusive. Each
district will appear many times in the column (there are over 1,500
Dave is assigned to districts 1,3,4,6,9,17 and 18.
Bill is assigned to districts 2,5,11,12,14,15 and 20
Mary is assigned to districts 7,8,10,13,16 and 19.
(I'm guessing at these assignments - the actual assignments may be
What I need to do is configure this spreadsheet so that when the
district number is ent...Data Validation With Multiple Criteria
I currently have a form that accepts sample measurements. Is there a way to
place multiple validation rules into a text box so that there is either a
measurement entered between 4" and 4.5" or the text box is left empty
as the other choice. (This last option would be to allow a person who
accidentally entered a measurement into the wrong text box to go back and
delete it without breaking the validation rule )
I'd greatly appreciate any advice on the best way to do this, Thanks, Adam
Private Sub YourTextBox_BeforeUpdate(Cancel As Integer)
If Not IsNull(Me.Yo...Pasting multiple cells using Office Clipboard
When I select two cells at the same time and copy them, they appear in the
Office Clipboard. When I click on the item to paste them, only one of the
cells appear on the worksheet.
This only happens when one of the cells I'm trying to copy is in a specific
Are the 2 cells that you're copying side-by-side or
If they're side-by-side, then it may be that when you try to paste to
the offending column, the next column across is hidden - that way the
paste is working right, but you just can't see it.
"doughboy" <doughb...print multiple DIFFFERENT labels in MS Publisher 2000
I am trying to print labels for my DVDs using MS Publisher 2000 and Avery
18167 labels (1/2 inch x 1-3/4 inches). I do NOT want to print 1 single label
in the middle of the page, nor do I want to print 80 of the same label.
What I want is to print "label A" in the label at Row 1 column 1, then
"label B" on Row 1 column 2, then "label C" in Row 1 column 3, etc. But I
can't find an option in either MS Publisher or MS Word 2000 that will allow
me to choose what row and column I want to start printing at.
Does this feature exist in either of those program...COUNTIF Multiple Conditions
How do I use countif with multiple conditions
Column B has dates
Column C has Various data or Blank
I need to count the number of non blanks in column C if column A is one
of 3 dates
I have tried the array formula below, but am getting the wrong answer
A6, A7 and A8 are the cells witth the dates in
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getin...Multiple lists in a cell
Is it possible to have a list range in one cell based on the inputed
information in that cell? IE, I have a packing list for 3 different
products, and 3 different master lists. On the 1st list, I have added in
list form in one cell the 3 different lists I could possibly generate. Is it
possible to change a list reference in the same cell based on the list I want
I think you need dependent list see Debra web
> Is it possible to have a list range in one cell based on t...Multiple Users of MS Money
I manange most of the finance, but I'd like to enable my
wife to pay bills and update statements and check register
info from her computer. We are currently running a linksys
wireless network in our home. Is there a way to allow two
or more users to do this? If so how can it be done
"Securely" is a function not of Money but of your network setup and
In general, see http://umpmfaq.info/faqdb.php?q=111. You would have to have
file sharing setup from the first machine to the second machine and have the
Money data file accessible for sharing. You would a...Access command to select from multiple reports
I have a command button on a form that I want to use to print one or
two of four letters (reports) based on the criteria tied to the
persons account. Right now my statement is this:
Private Sub Print_Invitation_Click()
On Error GoTo Err_Print_Invitation_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Evaluator Invitation Letters"
DoCmd.OpenReport stDocName, , , stlLinkCriteria
stDocName = "FA Pre-Festival Evaluator Invitation Letters"
DoCmd.OpenReport stDocName, , , stlLinkCriteria
stDocName = "KT Evaluator Invita...list with multiple repeated data
Hi, i have a column with a list of numers and letters, unsorted. the
data in this column can be repeated, it goes like this
I Need a way that this codes are copied into another column (col2) but
only once. if the code is 2 or more times in col1 it should be only
once in col2. is there a formula that allows me to do this on the fly
wothout recording any macro? the result shoul look like this:
all the codes are in col1, but they appear only once in Col2
Sorry to bother.
Thanks for all