Group data on X-axis on Excel graph
Posted on 2012-08-16
I have a tool that records some information (time, pressure & temperature) every second and I need to graph those curves in a time-based Excel graph. The problem I have is that Excel limits the X-axis labels to 255 and I have way more than that in the time column (tens of thousands of rows) and the graph only shows those first 255 rows of time and pressure giving me just a dot in the graph.
How can I group those time values so I get 10 minutes intervals or whatever I need? For example one label being 13:00:00 and the next one 13:10:00 and so on (while the pressure & temperatures keep "changing" in between). I would determine the length of each interval by dividing the total of rows by 255 so I know the maximum time between intervals (i.e. 10 minutes, 20 minutes, etc.).
Thanks a lot in advance!