Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text Box on a graph
I have read several questions and answers on this subject but I cannot get
them to work. I have Excel 2003. What I want to do is to place a text box on the graph where it equals a cell outside the graph and changes accordingly. The posts I have read say to select the graph first. However, when I select the graph the text box option is grayed out and not available. I can get the text box to display the data I want, just not on the graph itself. Any help would be appreciated. -- M. Shipp |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text Box on a graph
Select the chart, click in the formula bar, press =, then click on the cell
with your mouse and press Enter. This adds a linked textbox to the middle of the chart. Move it and format it to suit. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "SHIPP" wrote in message ... I have read several questions and answers on this subject but I cannot get them to work. I have Excel 2003. What I want to do is to place a text box on the graph where it equals a cell outside the graph and changes accordingly. The posts I have read say to select the graph first. However, when I select the graph the text box option is grayed out and not available. I can get the text box to display the data I want, just not on the graph itself. Any help would be appreciated. -- M. Shipp |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Text Box on a graph
On May 4, 6:00*am, SHIPP wrote:
I have read several questions and answers on this subject but I cannot get them to work. I have Excel 2003. What I want to do is to place a text box on the graph where it equals a cell outside the graph and changes accordingly.. The posts I have read say to select the graph first. However, when I select the graph the text box option is grayed out and not available. I can get the text box to display the data I want, just not on the graph itself. Any help would be appreciated. -- M. Shipp Draw a graph and press the right button of your mouse and select the item called "chart option" a small window will pop up go the tab called "data table" and check out the option called show data table. The movement you change the data in the work sheet automaticlly the graph and text box data will get changed. Heera |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph while ignoring text but not changing text to #NA | Charts and Charting in Excel | |||
How do I get the text at the top of m graph to run diagonally? | Setting up and Configuration of Excel | |||
Graph with text | Charts and Charting in Excel | |||
Text box in scatter graph | Charts and Charting in Excel | |||
how do i make a graph from text ? | Charts and Charting in Excel |