Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Resizing chart labels
Hi I was just wondering if there was a way to resize the labels on charts in
Excel 2007? I can click onto the label, but it doesn't allow me to change the size. The only way i can fit words onto a single line is by selecting a smaller font. Is there another way? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Resizing chart labels
Argent wrote on Tue, 24 Jul 2007 08:38:00 -0700:
A Hi I was just wondering if there was a way to resize the A labels on charts in Excel 2007? I can click onto the label, A but it doesn't allow me to change the size. The only way i A can fit words onto a single line is by selecting a smaller A font. Is there another way? Can you be a bit more specific about what you mean by chart labels? I just realised that you mentioned 2007. In the past, right clicking on the title would allow you to change the font etc. and left clicking the words. The only practical method to get a one-line title might be to change the font size. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Resizing chart labels
Sorry I'm not being very clear, I mean the data labels. Is there a way to
make the box wider to fit text into it? I have a column chart where I have reduced the gap width between each column so that the actual blocks are wider, but the data labels are still very small. Is there a way to widen it so that the text doesn't wrap to the next line? "James Silverton" wrote: Argent wrote on Tue, 24 Jul 2007 08:38:00 -0700: A Hi I was just wondering if there was a way to resize the A labels on charts in Excel 2007? I can click onto the label, A but it doesn't allow me to change the size. The only way i A can fit words onto a single line is by selecting a smaller A font. Is there another way? Can you be a bit more specific about what you mean by chart labels? I just realised that you mentioned 2007. In the past, right clicking on the title would allow you to change the font etc. and left clicking the words. The only practical method to get a one-line title might be to change the font size. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Resizing chart labels
Hi,
Although the text items in a chart appear to have sizing handles, when selected, you can not change the width or height of text elements. If you must have full control over textual elements you will need to add textboxes to the chart. The major draw back with this approach is the position of the textboxes will not change when the under lying data does. Cheers Andy Argent wrote: Hi I was just wondering if there was a way to resize the labels on charts in Excel 2007? I can click onto the label, but it doesn't allow me to change the size. The only way i can fit words onto a single line is by selecting a smaller font. Is there another way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resizing a Line Chart | Charts and Charting in Excel | |||
Resizing Chart window using VBA | Charts and Charting in Excel | |||
Resizing cells in a selection without resizing entire sheet | Excel Discussion (Misc queries) | |||
Resizing chart because of refreshing Chart Data through a query | Charts and Charting in Excel | |||
Chart resizing handles | Charts and Charting in Excel |