Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resize Data Labels
How do I resize data labels within a graph? I know how to resize the font,
but I need to know how to put the contents of the label on one line opposed to two. I cant seem to figure out how to resize the actual label. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resize Data Labels
Hi,
Basically you can't. You can not control the width or height of a data label other than by insert new line characters or adjusting fontsize. If you want complete control you need to use a textbox embedded within the chart object. This can be linked to cells if the content is dynamic. To add a textbox to a chart just select the chart and then type =Sheet1!A1 or the complete address of the cell you want to link to. If you do not need the link just type the text and when you press Return a textbox will be created. Cheers Andy daywata wrote: How do I resize data labels within a graph? I know how to resize the font, but I need to know how to put the contents of the label on one line opposed to two. I cant seem to figure out how to resize the actual label. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Custom data labels on a scatter plot | Charts and Charting in Excel | |||
Getting data labels right.... | Charts and Charting in Excel |