| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I edit label when cursor is placed on trendline in excel?
When you place a cursor on a trendline you get a data label with name and
point position. How do i edit what is displayed here- either htrough excel or using VBA? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I edit label when cursor is placed on trendline in excel?
Single-click on the label two or three times until the cursor appears in the
label. Now it can be edited. You may find it useful to change the number format of the label before editing it. Select the label (one click), go to the Format menu, select the top entry, and on the Number tab, choose a format with more decimal places, using scientific notation if required. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "DaveOG" wrote in message ... When you place a cursor on a trendline you get a data label with name and point position. How do i edit what is displayed here- either htrough excel or using VBA? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I have Excel cells populate a Word label template? | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Why can't I edit my excel document? Edit buttons shaded. | New Users to Excel | |||
| Why are the Edit, Insert and Format menus greyed out in Excel? | Excel Discussion (Misc queries) | |||
| How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
Linear Mode
