How to display data labels along bottom of a line chart
Hello.
How do I display data labels along the bottom of a line chart? If you look at the file I've attached, the data labels are displayed along the line chart itself. I'd prefer to have them all in a straight line along the bottom underneath the years. How do I do it?
For illustration, I want something like this (minus the line itself since I can't draw that here):
$250K
$200K
$150K
$100K
$50K
$0
2013 2014 2015 2016
$100K $150K $175K $200K <---this is what I'm referring to. I'd rather have the data labels here than along the line chart itself
Test-Line-Chart.xlsx
How do I display data labels along the bottom of a line chart? If you look at the file I've attached, the data labels are displayed along the line chart itself. I'd prefer to have them all in a straight line along the bottom underneath the years. How do I do it?
For illustration, I want something like this (minus the line itself since I can't draw that here):
$250K
$200K
$150K
$100K
$50K
$0
2013 2014 2015 2016
$100K $150K $175K $200K <---this is what I'm referring to. I'd rather have the data labels here than along the line chart itself
Test-Line-Chart.xlsx
Rob Henson
Sounds like you want a data table rather data labels. I will take a look at your file and come back to you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.