•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
Our take
If you're creating a bar chart to visualize common access times but are encountering issues with the x-axis displaying time ranges instead of individual time labels, you're not alone. Many users face this challenge when working with exported data. By adjusting your data formatting and chart settings, you can achieve a clearer representation, showing specific times like "08:00 AM" instead of ranges such as "07:50:37 AM - 08:20:00 AM.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Gantt chart (Stacked Bar)Hi all, ive been trying to make a chart with no luck. The chart should show the y axis with the list off staff members and the x axis the time from 6am to 2 am. Ive made a small chart for the data of staff names, shift start time and then the duration in hours. Start times formatted to time (eg 06:30) however im not sure how to format the duration. The x axis also keeps showing time through multiple days, and the data for duration seems to stretch too far than a few hours. Any help is welcome, im not well experienced in excel so i apologise submitted by /u/tmbsketches [link] [comments]
- Can Excel create a visual representation of when people arrived at and left a place based on time data?I am trying to create a visual aid and was hoping Excel might work, but this is definitely above my pay grade. I have data showing when people arrived at a location, when they departed, how long they stayed, and three categories for why they left. What I have in mind is a vertical bar chart with the vertical axis showing how long they stayed, and then each bar underneath it chronologically based on arrival time. I have attached a drawing showing what I have in my head. As a bonus, there are three different reasons for why people left. If I could color code each bar to correspond to one of those, I would be eternally grateful and send you an e-beer. https://preview.redd.it/fgs84rq0hbhg1.jpg?width=4032&format=pjpg&auto=webp&s=720f3153a53dc130ebe58b0e5b0a51ccc1934fd8 submitted by /u/RyanG21002 [link] [comments]
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