How do I edit label when cursor is placed on trendline in excel?

D

DaveOG

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?
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top