Adding Labels to an Excel 2010 Chart

contrain
contrain used Ask the Experts™
on
In the attached chart, I had some data on the worksheet that I need to add as a horizontal title on top of the chart and I'd like to know if there is some way to add the data to the chart directly from the sheet, or if I have to do it manually. In column D, Hours after Workout, I would like that to be the horizontal axis title above the chart and the corresponding numbers reflected as labels. I've attached a PDF that shows how it looks penciled in. The hours/days do not have to line up perfectly with the dots on the line chart, I just need the labels on top of the chart. Is there some way to do this by incorporating the data directly from the sheet, or do I need to create labels manually, and if so, how?

Thanks,
Line-Graph-of-Levels.xlsx
Labels-across-top-of-sheet.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
i am not sure if i understood the question correctly.

but if you want to add labels, you can use the free excel add-in of X Y chart labeler

http://www.appspro.com/Utilities/ChartLabeler.htm

Author

Commented:
Hi ProfessorJimJam,

I want to know if there is some way to include the data from column D in the worksheet into the chart that is already there. If there is a way to do this and use the labels from that column as a horizontal label on top of the chart, rather than on the bottom where the x axis labels usually go, that is what I would like to do. If that can't be done by just adding the data from column D to the chart, then I guess I'll have to add the data manually, or possibly use the add-in you recommended but I was looking first to see if this can be done without an add-in.

Thanks,
you can plot the labels against a secondary axis like in the attached and then remove the axis so that they appear to label the existing chart - is that what you need?

Setting it up can be a bit of trial and error so its worth looking at some of the chart sites like ozgrid.com where there are seriously complex versions:)
or for a more gentle introduction
data set on separate axis
Line-Graph-of-Levels-0v1.xlsx

Author

Commented:
Hi Regmigrant,

This looks like what I need. I'll delve into it further from the link you sent me and get back to you.

Thanks,

Author

Commented:
The Expert's solution provided me with what I needed, and the link sent to me as another resource is also helpful.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial