View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?