•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How can I get x-axis time labels on my bar chart to be normal
I am attempting to create a chart showing most common access times. I separated the hours and minutes from the access time information (exported from website to .csv), than got the times down to the nearest half hour. I would like there to be 48 possible times listed on the bar chart, showing how many times each occurred, but for some reason it's listed as a range like "07:50:37 AM - 08:20:00 AM" instead of just "08:00 AM". Anyone know a fix?
Put simply, I would like a single number (08:30 AM for example) and not a range of times.
[link] [comments]
Want to read more?
Check out the full article on the original site