•1 min read•from 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
Our take
Visualizing the occurrence of power outages over time can unveil patterns and trends that inform decision-making. By plotting outage times across various locations throughout the year, you can identify whether these occurrences shift in relation to other factors, such as temperature fluctuations. However, you may encounter challenges, such as duplicate values on the x-axis due to multiple outages within a single day. Addressing these issues will ensure a clearer representation of your data, enabling deeper insights into outage behaviors and their correlations with environmental variables.
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.
With the table in the image I get duplicate values in the x axis
[link] [comments]
Read on the original site
Open the publisher's page for the full experience