asked on Adding Labels to an Excel 2010 Chart
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
Thanks,
Line-Graph-of-Levels.xlsx
Labels-across-top-of-sheet.png
Microsoft Excel
Last Comment
contrain
ASKER
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,
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,
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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,
This looks like what I need. I'll delve into it further from the link you sent me and get back to you.
Thanks,
ASKER
The Expert's solution provided me with what I needed, and the link sent to me as another resource is also helpful.
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