"broken" y-axis in Excel charts
I often need to graph two parameters on the same bar graph whose high
values differ by a great deal - sometimes by a factor of 10 or 20 -
which makes the lower values almost disappear. I could use a second y
axis but sometimes it's inconvenient to do so. I have seen charts in
scientific journals that "break" the y-axis to indicate that the scale
has been compressed and partially hidden. Is this possible in Excel?
It would really come in handy sometimes.
burnsbyrne's Profile: ...Remove Duplicates
How can you remove filter records which are the same in 3 to 4 columns only
the ones that have in all 3 columns same wording
> How can you remove filter records which are the same in 3 to 4 columns only
> the ones that have in all 3 columns same wording
Assume the 3 cols are cols C to E
In F2, copied down: =SUMPRODUCT(--MATCH(C2:E2,C2:E2,0))=3
Then apply n autofilter for TRUE in F1, delete these filtered rows
please explain more detailed
also if we don't want todelete only copy the filte...CRM v4
I have a marketing list that contains more than one person from a company
(for some companies). I want to be able to remove the duplicates based on
title. Example: I want to be able to filter the list so if there is a CIO,
CFO and CEO I want the CIO and remove the CFO and CEO. If no CIO then keep
the CFO and remove the CEO. If no CIO or CFO then keep the CEO. The key is I
want the list to have one person per company but not exclude any companies.
I am pulling the list from Leads. Does anyone know if this is possible in
...Remove commas at end of line only
I have a column which contains part of an address eg.
"Honeyhouse, High Street,"
Is it possible to remove the comma at the end of the line but not the other comma?
for each c in selection
"Mark" <email@example.com> wrote in message
> I have a column which contains part of an address eg.
> "Honeyhouse, High Street,"
> Is it possible to r...Removing Hyperlinks
I am sure I have seen this question before on this newsgroup but can not
seem to find the thread.
Is it possible to remove hyperlinks in bulk from a worksheet or must they be
done one at a time?
Delete extra @ to reply
You can copy a blank cell and then Paste Special | Add to your selected cells.
However, this does add a zero to formulas...
= A1 + B1 becomes... = A1 + B1 + 0
San Francisco, USA
"john.bedford3" <john.bedford3@@ntlworld.com> wrote in message
> I am sure I have seen this ...Dotted line to remove
I have just been editing a multi-page word document and something I did has
made a dotted line appear. It goes across the page from margin to margin.
Whatever I do to try to remove it doesn't seem to work. The line was not in
the original so some I assume some key or setting I have touched has done it.
The Word I am using is MS Office Word 2007 - something I find is a lot more
fiddly than the older version I have used for years.
Any help would be appreciated.
<>>< ><&l...Remove existing property sets doesn't remove
I have created a new custom property sets in Visio 2003 Professional and it
will not allow me the remove the existing property set and replace it with my
...shared templates in Excel
How do I share a template folder between 2 computers on a
local peer-to-peer network? In Word, I can specify the
template location. How does it work in Excel?
I have Windows XP. Thanks.
...Tabbing between text boxes in Excel 2007
I have a spreadsheet that has multiple text boxes that I need to quickly type
info into and then tab to go to the next text box, this worked just fine in
2003 but since I changed to 2007 it does not allow me to tab between the text
boxes, any solutions? I would be happy to send someone an example of my
worksheet if that helps.
Select shapes with keyboard shortcuts.
...recently used file list in file menu not working and unreadable.
two problems, the first spawned the other, and both have taken hours=20
of time already (mostly in fruitless research) to try and remedy:
First problem: the recently used file list in the file menu is =
the files by their whole "pathname" and not merely by their filenames. =20
As new system architecture pretty much requires me to save things in=20
certain nested places, this is INSANE. the names are too long, and I=20
often have difficulty identifying my files. Previous versions of excel=20
seem to have been able to only display the filename.. I've been=20
searc...remove column in all email views
I put some add in to my Outlook 2003 about 8 months ago that was
supposed to help me keep track of my emails. I did not like it and
uninstalled it. However, any time I create a new mail folder now
outlook automatically makes a thread and categories column. How can I
get it to stop this behavior?
I would also like a way to remove all the categories and thread columns
in all my folders so I don't have to go into each folder and do it by
hand. I am a programmer so doing it programmatically is not an issue.
...Paid Invoice Shows Open
I have and open invoice that the monies have been collected on, plese see
How could I get rid of the remaining open invoice? When I printed it out
there was a strange
entry on the 2nd line or attached to the first line entry, I am not sure.
Unfortunately, you cannot attach documents or embed graphics when posting to
these newsgroups. At least, the person trying to view your message can't see
Please reply with more information.
Charles Allen, MVP
"P McCarthy" wrote:
> I have and open invoice that the monies have bee...Can you update links between workbooks without them both open?
Here is a simplified example of what I'm trying to do:
CarPayment.xls contains cells that list the loan amount, interest rate and
term. There is then a cell with the PMT function that calculates the car
payment. Budget.xls lists my expenses - it contains my rent, insurance and a
link to the cell in CarPayment.xls that stores the car payment amount.
There is also a cell in CarPayment.xls that contains my total expenses.
This is calculated via links back to Budget.xls - it simply adds the rent,
insurance and car payment.
So both workbooks are essentially dependent on each other. I...Removing "Maximize" from system menu.
I have a dialog based application. I want to completely remove the Maximize
and the Size entries from the system menu. They are grayed now, but I want
them totally removed. I just want a cleaner look since these will never be
How do I do this?
You could try making the main dialog have a Tool Window style set. It will
be smaller, but it looks nice.
"Paco" <firstname.lastname@example.org> wrote in message
>I have a dialog based application. I want to completely remove the Maximize
>and the Size entries f...Add "Significant Figures" to Number tab in "Format Cells" of Excel
Using Excel for science classes (the only classes I ever use Excel for) is a
pain because there isn't an easy way to deal with significant figures.
Sometimes setting the number of decimal places helps. Plus, it would be nice
if excel offered a method for dealing with the number "53,000,000" in which
it had 5 sig. figs. Scientific notation would be useful in this circumstance,
but usually I have to deal with, for example, "10" such that it has 2
significant figures. It really is a pain going through all the data fixing
it to deal with such simple matters.
I am...Outlook error on opening the first e-mail
I've got a customer who has the Outlook client for v4.0 installed since last
Friday and has the following problem since the following Monday morning when
she opened Outlook.
She opens Outlook without any problems, the CRM bar is present and she can
navigate in the CRM via Outlook.
But, the first e-mail that she opens triggers the following error message:
"Une erreur s'est produite lors du téléchargement de la fonctionnalité
Microsoft Dynamics CRM. Essayez de redémarrer Microsoft Outlook. Si l'erreur
persiste, contactez votre admistrateur syst&...ADODB.OPEN
I got recordcount = -1 when I use ADODB.open to get my recordset.
I just found the article from Microsoft,194973, that mentioned ADODB may
return -1 recordcount.
Any work around for this?
Your information is great appreciated,
...ADC removal problem
I want to go to native mode now that our Exchange 5.5
server is shut down but I cannot because I get an error
saying all connection agreements need to be removed.
I was able to remove 2/3 connection agreements, but now i
can't remove the 3rd. Config CA_SITE_SERVER
The 5.5 server has already been removed from the 2003
Check out the following article, specifically step 12:
272314 XADM: Preparing a Mixed Mode Organization for Conversion to Native
You need to remove the SRS, which will automatically take care o...Problem opening excel documents
We have a standalone workstation with Excel on it.
When a user double clicks on a spreadsheet to open it, Excel opens up, but
then the spreadsheet will not open. The message that comes up is something
to the effect of "path cannot be found".
If the user open Excel first and then using Excel's File-Open dialog box,
the file can be opened.
Anyone have any idea how to fix this issue.
Thanks in advance.
<Tools> <Options> <General> tab,
"Ignore Other Applications".
-----------------------------------...Tabs in Excel
I am wondering if there is a way that would allow me to
move down a row in one of my tabs, and when I went to any
of the other tabs, that same row would be displayed.
Almost like a synchronized movement within the tabs.
While holding the shift key, left click the tabs you want
to sync. Then what ever you do to one happens to the
>I am wondering if there is a way that would allow me to
>move down a row in one of my tabs, and when I went to any
>of the other tabs, that same row would be displayed.
>Almo...Removing/changing online Payees
I would like to change/delete/combine some of my online
payees. I know that you cannot combine online payees. Is
it possible to change an account so that it is no longer
an online account, then combine or change all the online
payees that I'm interested in, and then finally make the
accounts online accounts again?
...How do I break a hyperlink in an Excel document?
I have several hyperlinks to graphs within an Excel document, just on
seperate tabs. Now when trying to clear the contents and just type text into
that cell, it will not release the hyperlink. It only allows me to delete
the entire row or column, which I don't want to do because I would have to
re-create the entire document.
How can I simply break the hyperlink within the Excel sheet?
"Fulchp47" <Fulchp47@discussions.microsoft.com> wrote in message
news:A5F06...Will restoring CRM 3.0 databases to remove bad data cause offline client issues?
We recently did an import into our CRM 3.0 install, and would like to
restore our CRM Db's to remove that data. If we have Outlook clients that
are currently online, but have gone offline and back online agains since the
bad data was imported, what will the effect on them be? Will the data that
is removed from restoring the databases still be on the laptops? Or will the
next time they go offline will it be removed?
...Excel spreedsheets that are linked to other documents. #REF!
Ok, I've already posted why i get a value change even though i hit dont
update on my excel sheet. There was a regedit fix for it. However even though
i have that fix on this one particular file I still get the #REF! error.
This time what happens is this. I open the file, then i select dont update.
The values don't change. But as soon as I insert a new column my values then
change to #REF!. I can't figure this out. I'm stuck!
I'm currently running Office 2003.
>Ok, I've already posted why i get a value change even though i hit
&g...Removing a keystroke
Is there a way to remove all spaces within a column of cells? Extra spaces
are screwing up my subtotals. Thanks!
Select the cells to want to fix and then use Find/Replace
Gary''s Student - gsnu200909
> Is there a way to remove all spaces within a column of cells? Extra spaces
> are screwing up my subtotals. Thanks!
Select the column
what: (space character)
with: (leave blank--not even a space character)
Did you get this data from a web site?
If yes, then you could be seeing those...