We help IT Professionals succeed at work.

Excel

192 Views
Last Modified: 2015-01-13
How do I enter text in an excel graph box?


<<Microsoft Excel TA added to question--byundt, Microsoft Excel topic advisor>>
Comment
Watch Question

Mechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
It is also possible to add text as axis labels. You do this by:
1. Select the chart
2. You should now see a Design menu under Chart Tools. Click it, then choose Add Chart Element
3. Select Axis Titles...Primary Vertical in the resulting dialog. Change the resulting text to suit.
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
To add text to a data point:
1. Slowly, click the data point on the chart twice to select just it
2. Rightclick the data point, then choose Add Data Label...Add Data Label from the resulting popup
3. The data label will initially contain the value of the datum, but you can select that text and add your own. You can also drag the data label to one side to avoid hiding the point.
TextInGraphQ28582063.xlsx
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.