Thread: [Solved] Excel: Dates in a chart
View Single Post
 
Old 10-18-2016, 08:11 AM
Esaylikepie Esaylikepie is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2016
Posts: 5
Esaylikepie is on a distinguished road
Default

If you create a column with your dates (or row), 9/1, 9/2, 9/3 ect, select all your data points and then right click > go 'Format Cells' > select the 'Number' tab > Select category 'General', that I would assume should fix the issue of your input reverting back to 9/1/2016 ect...

RE your second question, have you tried turning off the 'Data Labels'? Click on the graph, and if you have excel ED 2013, click the green arrow that appears at the top right of the graph, deselect 'Data Labels'
Reply With Quote