If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Resize chart data label
Hi, I have chart data labels that are displaying as one line in Excel but
push over into two lines when paste/linked into a PowerPoint slide. Is there some way to force the labels to stay on one line? And as a general matter, is it possible to manipulate the size of the box containing the data label at all? I can select it but can't seem to resize manually. I also looked for info on this in VBA help but couldn't find anything. Any help would be appreciated. Kind regards, Don |
#2
|
|||
|
|||
Don -
You cannot resize a data label, an axis title, or a chart title, even though it looks like a real text box with eight little resizing handles when it's selected. This is the case manually and programmatically (VBA). A common workaround is to remove the pseudo textbox with a real textbox. The easiest way to get a textbox into the chart is to select the chart's plot area or chart area and just start typing. Whatever you type will be placed into a newly created textbox in the middle of the chart, ready for you to format and position. To link a new textbox to a worksheet cell, select the chart (as before), type the equals key, then select the cell. The formula bar shows the cell link, =Sheet1!$A$1. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ donesquire wrote: Hi, I have chart data labels that are displaying as one line in Excel but push over into two lines when paste/linked into a PowerPoint slide. Is there some way to force the labels to stay on one line? And as a general matter, is it possible to manipulate the size of the box containing the data label at all? I can select it but can't seem to resize manually. I also looked for info on this in VBA help but couldn't find anything. Any help would be appreciated. Kind regards, Don |
#3
|
|||
|
|||
Jon,
This workaround is fine for us. Thanks very much for your help. Kind regards, Don "Jon Peltier" wrote: Don - You cannot resize a data label, an axis title, or a chart title, even though it looks like a real text box with eight little resizing handles when it's selected. This is the case manually and programmatically (VBA). A common workaround is to remove the pseudo textbox with a real textbox. The easiest way to get a textbox into the chart is to select the chart's plot area or chart area and just start typing. Whatever you type will be placed into a newly created textbox in the middle of the chart, ready for you to format and position. To link a new textbox to a worksheet cell, select the chart (as before), type the equals key, then select the cell. The formula bar shows the cell link, =Sheet1!$A$1. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ donesquire wrote: Hi, I have chart data labels that are displaying as one line in Excel but push over into two lines when paste/linked into a PowerPoint slide. Is there some way to force the labels to stay on one line? And as a general matter, is it possible to manipulate the size of the box containing the data label at all? I can select it but can't seem to resize manually. I also looked for info on this in VBA help but couldn't find anything. Any help would be appreciated. Kind regards, Don |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Hide the data label for a data table in a chart | Kathy | Charts and Charting | 2 | April 24th, 2005 03:29 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |
Embed data in graph | wrace | Charts and Charting | 5 | May 5th, 2004 04:39 AM |
Help with Data (Table) below my chart | Jon Peltier | Charts and Charting | 0 | November 20th, 2003 03:36 PM |