Why do my pie charts have labels which say "add text"?
Using Excel 2007 and my template comes up with this add text label for
multiple labels on the pie chart. Even when I save a new template it still
...SCW adding strange Services into GPO
Every time I run the MS SCW (Security Configuration Wizard) on W2K3, it
enters the below strange Services into the resulting XML and finally into the
GPO, always spelt in lower case.
It doesn't matter which server type I select.
Question: Why does it do and can I stop it?
- edi subsystem
...Query from three tables, problem when adding a record
I'm using Access 2002/2003.
I have three tables A, B and C.
Table A has a primary key, which is linked to corresponding foreign keys in
tables B and C.
The values of the keys are unique in their respective tables. In all three
tables, each value occurs at most once.
I am using a query Q showing all rows of A, and the rows of B and C in a
The query Q allows me to add a new record two A.
And I can also add a new record to B and a new record to C at the same time
(in the same query row !).
But, in case that I add a new record to A only and then leave the query,
open...Graphs/Charts by country. Same Graph, different Source Data
I have sales information for 5 countries, each on separate sheets ( the
sheets are identical in format) . I have made graphs for the first country,
and I want to copy them to the other countries, and change the references to
pick up the right country information. Is there a quick way of doing this or
do i have to go into source information for each series for each graph and
change the sheet( country ) reference
I asppreciate any answers to this as atthe moment I've spent the better part
of a day changing sheet references
...adding largest numbers
I want to add the largest five numbers in a range, which will change daily.
I have put a condition on to highlight the top five and that is working. I
don't know how to add the largest five numbers since the largest 5 numbers
will change from cell to cell daily. I am assuming you would use a SUMIF,
then range, but how do you write a critieria for the largest five numbers?
Thanks for helping a beginner.
"nrbrtsn" <email@example.com> wrote in message
news:5E0744A0-...How to calculate text according to multiple months?
I', having a slight problem with my Excel-worksheet. I have a sheet with
data, like this:
How do I get Excel to count all the X:s in the first three months? I have
another sheet to gather this data in which I'm putting the formula.
Assumes no empty cells in the data range.
Microsoft Excel MVP
"Joona" <Joona@discussions.microsoft.com> wrote in m...Some text boxes on an embedded chart do not show up
Why is it that the last one or two text boxes on an embedded chart do not
display when I click outside the chart area?
I am using 16 text boxes on a chart instead of the legend as it makes it
easier to read. I then select an area that includes the chart and copy it
to Paint (see note 1), where I save it as a JPG as I want to load it onto
the web. The Excel file and the JPG file can be found at the following links
Why is it that the last one or two tex...calculating multiple fields in an unbound text box
I have a report based on a query that links 2 tables by the field "Type".
Each tiype in the one table has a minimum price. The other table has the type
and actual sales prices in four different fields of which only one is used in
the calculations. I am calculating the difference between actual selling
price and minimum price.
the problem I am having is that although the minimum price is always
desplayed for the type, the calculation does not work for the different
fields. If the first field is null, then the next 3 fields should be checked.
The other fields may or may not be ...Prediction Graphs
How do i make a graph predict the next value from 3 tables with info
eg Table 1 has 5$ profit
Table 2 has 3$ profit
Table 3 has 8$ Profit
how do i make a graph which predicts the next set of values from these
peabushmartin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27399
View this thread: http://www.excelforum.com/showthread.php?threadid=469414
The mechanics of getting a chart to predict future values is easy.
Chart your data in the desi...Having a row adjust in height to accommodate text entry
In a form that I'm developing I have 4 columns and 5 rows. I would like for
the row height of all rows to automatically adjust to accommodate the text
entry in any given colum/cell. Is there an easy way to accomplish this? Will
it make a difference whether the worksheet is protected or not?
On Thu, 7 Jan 2010 10:50:06 -0800, John wrote:
> In a form that I'm developing I have 4 columns and 5 rows. I would like for
> the row height of all rows to automatically adjust to accommodate the text
> entry in any given colum/cell. Is there an easy way to ...Cannot copy text in emails
I am experiencing rather an annoying problem with outlook 2000 and Win2K
Here is what I'm doing in step-by-step form.
View an e-mail in outlook 2000, highlight some text in this e-mail, using
either the keyboard shortcut CTRL+C or right mouse to copy the text.
Open a new email message , try to paste the copied text - nothing is
available to paste.
If I open notepad or Word, the text can be pasted . It's only Outlook which
has the problem.
The work around is to open the new email first then go to the email with the
text required to copy and go thru the procedure like that.
Anyone ...How do I read text file in an EXCEL SHEET
With regards to EXCEL how we read the text file in EXCEL sheet using
The file is located in d:\Sql\Documents\Amit\log.txt.
I want to save the EXCEL sheet, and every time when I open this sheet
it reads this text file and displays the contents of this text file in
I want to use MACRO for reading this text file.How I do that?
fileName = "D:\Sql\Documents\Amit\log.txt"
Workbooks.OpenText FileName:=fileName, Origin:=xlWindows, StartRow _
:=1, DataType:=xlFixedWidth, FieldInfo:=Array( _
Array(0,...converting text to formulas
Is there a way to convert text to a formula?
I have a pattern of data that I am trying to convert to formulas. In one
column I have a pattern of A,A,A,A,B,B,B,B,C,C.... In the next column I
have numbers 1,2,3,4,1,2,3,4,...
Using the concatenate function I can generate a column of
but this is just text. I really am trying to generate the values that these
cell references would represent. The goal is to present the DATA from cell
A1, A2, A3, A4, B1, B2...all in a long list.
Does this make sense? Can this be done?
Thanks a ton for your help!
...how to overlap 2 graphs/2 scales to relay information
I have 2 graphs, one with sales, and the other with service times, i need a
way to display results on one graph.
You could use the custom Charts and select the line chart on 2 axis.
This way you can plot two series of data that have different values on
the same chart. best way is to just give it a go.
infojmac's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10787
View this thread: http://www.excelforum.com/showthread.php?threadid=543725
...How do I get the text from running off a page (have it skip to th.
I need to be able to have text skip from one cell down to the next row
without it running off a page (hard return)
Not sure what you need here.
If you want text to stop at a certain point in a cell then drop down to next
cell below, just hit ENTER key whenever you choose.
If you want the text on more than one line in a cell, you can hit ALT + ENTER
to create a CR in the cell.
Or just type it all in one cell then choose Wrap Text and widen the column.
Gord Dibben Excel MVP
On Fri, 15 Apr 2005 14:48:03 -0700, "Amy Maestas" <Amy
Maestas@discussions.microsoft.com> wro...Run code when text box content deleted
I am trying in vain to have the following run when the value of a text box
If txtDateReady = "" Then
Me.lblWhyDelayed.Visible = False
Me.txtWhyDelayed.Visible = False
I have tried in 'txtDateReady_LostFocus' and 'txtDateReady_Change' but
> I am trying in vain to have the following run when the value of a
> text box becomes ""
> If txtDateReady = "" Then
> Me.lblWhyDelayed.Visible = False
> Me.txtWhy...Outlook does not find Notes by Cyrillic text in them
Outlook 2003 sp1 and 2002 sp2 do not find Notes by Cyrillic text in them,
only by Latin text and digits. How to make Outlook 2003 sp1 find Notes by
Cyrillic text in them?
������� Outlook 2003 sp1 � 2002 sp2 �� ������� ������� �� ��������������
������ � ���, ������ �� ���������� ������ � ������. ��� ��������� Outlook
2003 �������� �� �������������� ������?
...What exactly is "frequently-used text fields" looking in?
Running Outlook 2003. When you do an "Advanced Find" anywhere in the Folder
Tree you get three choices at the top underneath "Search for words"
subject field only
subject field and message body
frequently-used text fields
What exactly is "frequently-used text fields" looking in?
it depends on the item type you are searching for. In contacts, it's name
and address and notes field.
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/...Adding Products to quotes
I am still new to CRM 3.0 but I have more than 10 years experience with
MBS-Dynamics - GP. In CRM when I enter a new quote it appears that I must
save the quote 'header" before I can add products; i.e. the products link in
the Details tab is not active until I press the save button.
Is this correct? Is this the design?
In Great Plains we can enter header information and go straight in and add
products - we do not have to save the order before adding SKU's.
If I am missing some step in the process please let me know. I would hate to
do a demo only to discover later on th...Text wrapping 11-15-09
I am working on a 16-page newsletter. On at least two pages, a text frame or
picture inserted into another text frame with type in it, will not push the
type aside and allow it to flow normally around the inserted frame or
picture. The new text frame or picture simply lays over the existing type, as
though its a piece of paper taped to a printed sheet. This happens no matter
what setting I make on the Text Wrapping tool.
Yet, on other pages in the same newsletter, an inserted type frame or
picture, when placed into an existing text frame with type, will push the
type aside as ...How can I find a text box that has disappeared due to resizing (M.
In MS Excel 97 or 2000 if a text box (autoshape) is resized somehow so that
is no longer visible, how can you find it (and delete it) on the worksheet.
I've apparently got several lengthy text strings in text boxes I can't see,
but the spell checker obviously "sees" them because I'm getting prompted to
correct spelling errors in them. I'd like to delete the text boxes, but I
can't find the darn things.
To select specific objects, you can add the 'Select Multiple Objects'
tool to one of your toolbars:
Select the Comm...Adding to Word Editor Toolbar
I have a mail registration addin (allows registration of emails into a 3rd
party records management database). I have programmed the addin to add a
"Register & Send" button onto the Standard toolbar which appears when using
outlook as the email editor. However, when you use Word as the editor,
another toolbar appears which has the Send button on it. I would like to
place my button "Register & Send" beside it. However I cannot seem to access
this toolbar, I have created a function to output the toolbars and their
controls to a text file, but cannot see thi...Renaming a Word document from text in controls
Access 2003/XP Pro
I'm opening a Word document, typing some text, and trying to rename it using
text from a combo and a text box on my form. The first two steps work OK, but
when I try to rename the document, it comes up with a message box "Object
Dim oWord As Object
Dim oDoc As Object
'Create the Word application object.
Set oWord = CreateObject("Word.Application")
'Open the sample document.
Set oDoc = oWord.Documents.Add("C:\t2hDoc\DocBlank.doc")
'...Pivot charts and graphs ?
I know pivot charts are used to "summarize" the data. but if i have a
A 20 24 83.33
B 16 24 66.66
where the fourth column is calcuating the 2nd/3rd * 100. basically
Now if i want to draw a graph its easy, but if i want it to be drawn
through a pivot table ? ie a pivot chart how would i do it. Now my
question is in what format my data should be so that i can draw a
similar graph which shows A and B and their percentages.
NOw i know i can use calculate field , but you see eventually i want it
to be published on "share point" where the only graphing...Wrap Text #6
I just installed the SP2 for Office 2003 and now "wrapped" text does not
appear in my cells. They are not merged cells. Prior to updating, the wrapped
text automatically fit my text. Since updating, even if I manually resize the
row the text does not appear until I double-click the cell. Once I leave the
cell, the text disappears again?
When I turn off "wrap text", the text reappears.
Has anyone else experienced this? Is it a bug? Is there a workaround?
I've never noticed a problem with a specific version of excel. But in all
versions, if the text ...