•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
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#real-time data collaboration
#real-time collaboration
#Excel compatibility
#Excel alternatives
#time labels
#bar chart
#x-axis
#access times
#CSV
#time format
#hours and minutes
#time range
#half hour
#single number
#occurrent times
#data visualization