Adding text onto a Graph

I want to add a note on the bottom of some graphs to 
indicate who they were produced by.  Have tried adding a 
text box, but this disappears when I select the graph for 
Note: I have several graphs on one worksheet.
Can someone please tell me how to do this.  Thanks lots.
anonymous (74722)
4/19/2004 4:48:54 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 40

Hi Gaye,

The simplest way is to select the chart and the just type some text.
A textbox will be created that is embedded inside the chart instead of 
just over it, like it would appear you currently have.

To make the textboxes you have already created part of the chart select 
the textbox and prs CTRL+X now select the chart and press CTRL+V. Again 
the textbox shold now be embedded in the chart.


Gaye wrote:

> I want to add a note on the bottom of some graphs to 
> indicate who they were produced by.  Have tried adding a 
> text box, but this disappears when I select the graph for 
> printing.
> Note: I have several graphs on one worksheet.
> Can someone please tell me how to do this.  Thanks lots.


Andy Pope, Microsoft MVP - Excel
andy9699 (3616)
4/19/2004 9:35:46 AM

Similar Artilces:

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 happens. Why? ...

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? - 6to4 - adam_isastgctrl - adtagent - adtserver - appmgr - binlsvc - ddm001 - ddm6db - ddm999 - dmlservice - dns - drdaresync - edi subsystem - elementmgr - entsso - fpnw - fwsrv - groveler - ifssvc - imap4svc ...

Query from three tables, problem when adding a record
Hi ! 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 linked fashion. 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
Hi 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 Rgds Dan ...

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. Try this, =SUMPRODUCT(LARGE(A1:A100,{1,2,3,4,5})) HTH Regards, Howard "nrbrtsn" <> wrote in message news:5E0744A0-...

How to calculate text according to multiple months?
Hello! I', having a slight problem with my Excel-worksheet. I have a sheet with data, like this: A B 1.1.2010 X 2.2.2010 X 3.3.2010 4.4.2010 X (A: DDMMYYYY) 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. One way... Assumes no empty cells in the data range. =SUMPRODUCT(--(MONTH(A1:A20)<=3),--(B1:B20="x")) -- Biff Microsoft Excel MVP "Joona" <> 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 values? -- peabushmartin ------------------------------------------------------------------------ peabushmartin's Profile: View this thread: 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? -- John 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
Hello, With regards to EXCEL how we read the text file in EXCEL sheet using MACRO. 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 Excel Sheet. I want to use MACRO for reading this text file.How I do that? Thanks Amit fileName = "D:\Sql\Documents\Amit\log.txt" Workbooks.OpenText FileName:=fileName OR Workbooks.OpenText FileName:=fileName, Origin:=xlWindows, StartRow _ :=1, DataType:=xlFixedWidth, FieldInfo:=Array( _ Array(0,...

converting text to formulas
Greetings, 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 =A1,=A2,=A3,=A4,=B1,=B2.... 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 ------------------------------------------------------------------------ infojmac's Profile: View this thread: ...

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) Amy 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> 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 becomes "" If txtDateReady = "" Then Me.lblWhyDelayed.Visible = False Me.txtWhyDelayed.Visible = False End If I have tried in 'txtDateReady_LostFocus' and 'txtDateReady_Change' but nothing happens. Help appreciated. Sandy Sandy wrote: > 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
Hello 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?
Gurus, 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? -- Spin 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? Outlook 2007:

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: Choose Tools>Customize Select the Comm...

Adding to Word Editor Toolbar
Hi gurus! 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 required ". 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 table like A 20 24 83.33 B 16 24 66.66 where the fourth column is calcuating the 2nd/3rd * 100. basically percentage. 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? Thanks Mark. I've never noticed a problem with a specific version of excel. But in all versions, if the text ...