Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Replacing Chart title with Text box
Hi. I'm attempting to replace a Chart Title with a text box so I may re-size
it. However, when I delete the original Chart Title box, the entire chart moves up, causing the data labels to overlap the Chart title. Is there any way to replace the Chart Title with a Text Box and prevent the chart from shifting? Thanks in advance. -- Neil T |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Replacing Chart title with Text box
Hi,
Why not set the chart title to a space. This will hold the position of the other chart elements and not obscure the textbox you are adding to hold the title. Cheers Andy Neil T wrote: Hi. I'm attempting to replace a Chart Title with a text box so I may re-size it. However, when I delete the original Chart Title box, the entire chart moves up, causing the data labels to overlap the Chart title. Is there any way to replace the Chart Title with a Text Box and prevent the chart from shifting? Thanks in advance. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Replacing Chart title with Text box
Also, you can select the plot area, and drag it back into the shape you
need. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... Hi, Why not set the chart title to a space. This will hold the position of the other chart elements and not obscure the textbox you are adding to hold the title. Cheers Andy Neil T wrote: Hi. I'm attempting to replace a Chart Title with a text box so I may re-size it. However, when I delete the original Chart Title box, the entire chart moves up, causing the data labels to overlap the Chart title. Is there any way to replace the Chart Title with a Text Box and prevent the chart from shifting? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
axis title text box is wrong size in chart for excel 2003 | Charts and Charting in Excel | |||
Chart title text linked from a cell? Possible? | Excel Discussion (Misc queries) | |||
Chart Title or Text Box Linked to cell & sheet | Charts and Charting in Excel | |||
dynamic chart title text | Excel Discussion (Misc queries) | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel |