1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Visualise ocurrence time of events that can happen multiple times a day

I'm trying to plot power outages times over the year. An outage can happen multiple times a day and I want to see if the ocurrence time moves over the year (or later compare it to other variables like temperature trough the year) The different colunms are different locations.

https://preview.redd.it/hajoeue79tmg1.png?width=935&format=png&auto=webp&s=96ac972aae577bf76708993469d51d73f20a1293

With the table in the image I get duplicate values in the x axis

submitted by /u/Matthanol
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#real-time data collaboration
#real-time collaboration
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#power outages
#ocurrence time
#plot
#data visualization
#events
#locations
#temperature
#time series
#duplicate values
#multiple times
#analysis
#trend
#x axis