sqlagent007
asked on
Excel 2013 data visualization with a simple 2 column X and Y data points
I have a simple 2 column sheet in Excel. The Y axis is fine showing "count" and then showing a number scale vertically. However on the X axis, the horizontal labels show numbers 1 - 11. I want them to show the DAY and HOUR or just the HOUR.
I am not sure how to update the X labels to show the date/time values across the bottom labels. I want the values in the column "DAY_TIME" to be the labels across the bottom row where the number 1-11 are listed.
I am not sure how to update the X labels to show the date/time values across the bottom labels. I want the values in the column "DAY_TIME" to be the labels across the bottom row where the number 1-11 are listed.
ASKER
Now it shows the X axis as numbers, the chart appears to be interperting the dates as number(8,2) data type. See new version of the sheet.
ASKER
ASKER
I would like the X axis to show "DATE / HOUR" example: [10/14/2016 7:00:00 AM]
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!!!
You're welcome!
Of course, an example file would be much more helpful in finding a solution for you.
Regards,
-Glenn