Excel 2007 charts resizing unexpectedly
On opening an Excel 2007 sheet with charts, I often find that the charts have
resized themselves: they are either too big to fit on the screen, or have
A work-around is to use the 'move chart' menu option to move the chart to an
object in another sheet and then move it back again as a new sheet. However,
the font sizes are then messed up.
...Multiple Exchange Servers
Is it possible to install ms-crm email router on more then one Exchange
Server in the same domain that will work with a single crm server?
Also, is it possible to install the email-router on 2 exchange servers that
one of them is in a different domain and both of them will work with a single
crm server that resides in one of these domains?
Is there a change in this cases in verion 3.0 (vNext)?
There is definately a change for v3. The support for multiple servers is
much better in v3, but not sure how it will handle the multiple Domain
For v1.x, it could work, but depends a lot ...Summary sheet for multiple sheets (difficult problem)
Here's the scenario: people owe money to companies. We assign each of these
people a number, and create a separate sheet for each of the many companies.
We need to compile a summary sheet (within the same workbook). Here's a
sample sheet (let's call it Sample Company, which is the name of the sheet):
Name ID # Amount
John Jones 555 500
Jim Smith 123 175
Mary Long 232 100
Thus far the workbook has about twenty sheets (not counting the summary
sheet) each named after a company and additional sheets are added freque...Multiple Payees
I am using Money 2002 v10.0
My banking institution sends its transactions inclusive
of transaction fees. At the moment I am 'Split'ing
categories to show the fees, which makes my budget look
OK. However the bank fees are showing against the Payees
and not the Banking institute, so my Payee balances are
Is there a way I can also 'Split' a transaction into
multiple payees as well as multiple categories
EG.. Paying the phone bill:
Phone company $20.00
Bank Fee $0.50
Total Trans. $20.50
Although I only paid the phone company $20.00 it shows as
I mistakenly delete all mails from Inbox and then found them on the deleted Items and selected all and ask to move folders back to Inbox.
the problem is all mails were combined into one email and moved back in to Inbox as a single email.
How do i go back to the original version. How do i uncombined all the mails in to individual mails from the right recipient? Please help ASAP..
Submitted using http://www.outlookforums.com
...How can I create a chart to compare multiple data series?
Using Excel, is there a way to merge multiple charts with different data
series into one to demonstrate a direct comparison of the data series within
one single chart. I've got 4 charts of the stacked column type.
Tufte calls them small multiples, Cleveland calls them trellis displays. I
call them panel charts.
Take a look at the examples on this page.
Another option is to stick with your 4 charts, however, you can size and
align them. Here's a link to a simple macro that sizes and aligns all charts
on a single sheet....changing colours of multiple items in Publisher 2000
Does anyone have any idea how I can change the colour of multiple items on a
page? It is so time consuming to have to select and change the colour of
each item individually - it would be so useful to be able to select all the
items I need and change the colour en bloc.
Do the newer Publisher packages have this facility (2003, 2007?)
What items are you trying to chage?
MVP Microsoft [Publisher]
How to ask a question
"Fluffbrain" <Fluffbrain@discussions.microsoft.com> wrote in message
I need to merge about 75 worksheets into one spreadsheet on a regular basis -
all have exactly the same format/layout etc back can vary in the number of
Try this Jeff
Regards Ron de Bruin
"Jeff224" <Jeff224@discussions.microsoft.com> wrote in message news:C6790506-2888-4F4D-80EA-BB0D9F9B27A2@microsoft.com...
>I need to merge about 75 worksheets into one spreadsheet on a regular basis -
> all have exactly the same format/layout etc back can vary in the number of
http://www.rondebru...Multiple calls for Campaign
Hello I am attempting to set up a telemarketing campaign by using quick
campaign in Microsoft CRM 4.0. I have set up the marketing list with
multiple contacts and created a quick campaign for this marketing list.
While creating the quick campaign, I selected phone call to all of the
contacts within the marketing list. However, a phone call task was not
created for every contact within the list. Only one phone call task was
created for the entire marketing list.
How can I create multiple phone calls for each and every contact within the
marketing list. Kindly advise. Thank you
...Finding the combination that appears more times
i have a list on excel 2007 that displays the purchase of items on columns
A:E, each column showing one (1) item
I want to find what combination of items appears more times, especifically,
which combination of four (4) is the favorite mix
A B C D F
A C D E F
B C D E F
B C D F Z
in this example, the winner would be (B, C, D, E) as it appears 3 times
the main problem is that I have over 1,000 rows
and trying with =SUMPRODUCT(COUNTIF(A1:E1,$N$1:$R$1)) por each combination
would take forever...
is there a simpler, quicker ...multiple account registers
Been using Money for years, now I'm taking on my mother's finances and would
like to track them in Money but in a separate account register. How can I do
this, or other options for keeping her accounts separate from my own?
In microsoft.public.money, Needinghelp! wrote:
>Been using Money for years, now I'm taking on my mother's finances and would
>like to track them in Money but in a separate account register. How can I do
>this, or other options for keeping her accounts separate from my own?
Use File->New->Newfile (or similar with an older version) to cre...creating chart from different sheet
Looking for the method to create chart in Excel sourcing cell from
different sheets, instead of same sheet.. I already tried hold CTrl key
but it gives the format error when i try to add series to the chart if
the data is from the two different sheets.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
All the data for the values for one axis for a series on a chart must
be on a single worksheet. So, all the x-values for a series must be on
a worksheet, just as al...Average IFS (Multiple Criteria)
I have used the following formula and it works prefectly, however, one of my
columns contains % and I want an average not a sum.
Is there a way to use AVERAGEIFS to get the average only if other cells
contain certain criteria?
...Combining 2 Excel (xls) files
I have 2 xls workbooks with different sheet names and both with
different range names. I would like to combine them both into one
workbook so that I don't have to re-create all of the range names. Is
there a way to do that?
LAF's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9656
View this thread: http://www.excelforum.com/showthread.php?threadid=346017
Open both files (let's call them A & B, and assume A will be your "combined"
Working i...Emails to multiple recipients not being delivered
Windows 2000 Server SP4
Exchange 5.5 SP4
We've had multiple complaints about people not being able to send to
multiple recipients in the "To:" field. For example:
John Doe, Jane Smith, and Mike Brown are all listed as the "To:" recipients
of an email. Jane Doe gets the email but nobody else listed does.
We have had a few people tell us about this problem. Somtimes all
recipipients will get the email but sometimes not. Are there any settings in
Exchange 5.5 that will prevent this? Thanks in advance.
On Mon, 8 Aug 2005 16:02:02 -0700, "Mr. Mike"...Opening Multiple files in separate Excel folders
Can this be done?
what do you mean with 'separate Excel folders'?
Paul Dunn wrote:
> Can this be done?
Dim i As Integer
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFSO = Nothing
Dim Folder As Object
Dim Files As Object
Can I combine two different publications into one?
> Can I combine two different publications into one?
Personally, I would simply open two instances
of Publisher (one document in each) / tile the
two screens...and copy/paste.
Maybe the following link will be useful:
Combining Publisher Documents
MS Picture It! -
Digital Image MVP
Highlights and FAQs
This is not tech support
I am a volunteer
Solutions that wo...How do I update charts in excel 2007
I'm tracking and charting real estate data in three cities, by month. I can
add updated info into the worksheet columns, but I can't get the
corresponding points into the line chart that I made three months ago from
Now using excel 2007. Had no trouble with this task in excel 2003, becouse I
could easily change the data range and then the chart followed the changes.
I'm new in 2007, and when I find the data range and change it to correspond
the with the updated columns nothing happens in the chart
I have a line chart on the s...How to Combine Data in Different Columns
I need help in this issue. I have tried many ways though some wer
successful but they were not efficient.
I have say 5 columns of data and the data could be on the same rows o
all 5 columns or on different rows hence if I need to combine all th
data of these 5 columns, I would have to sort or filter each of the
manually and copy and paste to a different worksheet or column. This i
very tedious and time consuming. I also tried to write a macro to loo
for data in one column then put them into another column but i was no
successful. However, experts like you guys shouldn't have ...newb question
Hi all, new Outlook 2003 user here with a problem. Here's the issue: I have 2 email accounts in my life, a hotmail account, and my work email account. I've set them both up as seperate email accounts in Outlook, and both work just fine. But here's the rub: In order to connect to my work email account (which is set-up as an exchange server email account) I have to first connect using VPN software on my PC. I only really want to check my work email once or twice a month, so therefore I don't want to fire-up my VPN software every time I open Outlook. My hotmail, on the other...combinations
I have a finite number of values that represent length (right now I have
less than 20 values). Can Excel take these values and list all possible
combinations of the values?
Any pointers appreciated.
No. There are 2,432,902,008,176,640,000 possible ways to combine 20
different values. That is, unless you have another limitation, like only
using 4 at a time....
MS Excel MVP
"Stephen R" <firstname.lastname@example.org> wrote in message
> I have a finite number of values that represent length (right...Scatter chart for real-time tracking of a single cell value ?
Hi. I use Excel 2003. On a spreadsheet connected to a DDE data feed, I
have a cell containing an integer number that updates and changes
constantly during the day.
I would like to chart the number in that cell in real-time second by
second between certain hours of the day. I have been told that it may
be possible to use a scatter chart to do this but I have not been able
to make it work or to find useful help files. It seems to me that the
problem has to do with charting a single cell rather than a range but
I'm not sure.
Any practical advice or pointer to a "how-to" web site w...Multiple Conditions
I am trying to populate a field on a form if certain conditions are met such
If checkbox1 is true then display x
If checkbox 2 is true then display y
If both are true then display z
If both are false then display w
Any help will be greatly appreciated!
Use Switch(), Choose() or nested IIf() expressions.
See the help in Access for details an examples.
If you actually have lots more checkboxes than the 2 in your example, you
might get better results by redesigning the table:
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for ...Set up multiple email accounts on Outlook 2002, so that the mail .
I would like multiple email accounts, in separate folders, so my family,
business and consumer mail do not comingle, whether sending or recieving. At
present,, they are comingled, and I cannot find the right way to correct this.
The easiest method is to use profiles, one for each purpose. Otherwise, you
can use rules to move mail when receiving and sending.
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 searching...Multiple sub forms
I have a main form that has 3 subforms all linked by date. What I would like
to do is when the data has been entered into 1 subform and I go to the next,
have the 1st subform shrink, and the same for the 3rd subform. Is this
possible? I am using access 2007
> I have a main form that has 3 subforms all linked by date. What I would like
> to do is when the data has been entered into 1 subform and I go to the next,
> have the 1st subform shrink, and the same for the 3rd subform. Is this
> possible? I am using access 2007
A subform is really a cont...