Forum Discussion
probably one of the dumbest questions ever here - creating a 24hr bar chart where the times are prop
Hi, I'm embarrassed to ask this, but I'm trying to create a very simple bar chart of events happening at random times over 24 hours. I can plot the events ok, with time labels on the X-axis, but I ca...
Since you know how to create the graph, that's not the real question. It's how to create a source of data for that graph.
We sometimes talk of creating "helper columns" to facilitate solutions. In this case, I'm suggesting a "helper table"
Unless you require precision at the exact level of minutes (you do have one time stamp with 12 minutes), you could create a table of the 24 hours with each five or ten minute interval labeled, and then use VLOOKUP to retrieve from your actual data table the figure that is closest to that five or ten minute interval. Then make the graph from that table instead of the actual randomly recorded one.