Hey guys!
Not sure if this is possible, but thought I'd ask anyway. So I have a data set that looks like this (there's many more data points than these, I just chose random ones for an example):
As you can see, there are multiple data sets that can span over a few different days, any hour of the day. I made a graph that contains all the data sets and currently the x-axis is formatted as text so that the labels appear as they do in the Date and Time column. So each label will be a random point and it will follow that format (include the date and the time). This formatting makes the x-axis look very cluttered as there are many data points. I'm just curious to know if there is a way that anyone knows of so that I can change the formatting of the x-axis so that its only time, but the date will appear below the times that occur on that date. I'm not sure how best to explain it, so I made a table in excel and I'll share the screenshot of what I'm imagining below.
First screenshot is what the formatting currently looks like (as you can see, its jammed together and kinda looks like a wall of text):
Here's my best artistic rendering (using excel tables) of what I'm wondering if I can change it to somehow within the table axis:
Basically, just groups all the times on a date then shows the data below just so its a little neater. Like I said, I'm not even sure if this is possible (and if not I'll just roll with my current format), but I'd figure I'd ask people who probably know a lot more about excel than I do!
Thanks for your help!
Not sure if this is possible, but thought I'd ask anyway. So I have a data set that looks like this (there's many more data points than these, I just chose random ones for an example):
| Date and Time (mm/dd/yy hh:mm AM/PM) | Data Set 1 (Temp) | Data Set 2 (Temp) | Data Set 3 (Temp) | |
| 02/05/20 04:13 AM | 54 | 58 | 53 | |
| 02/05/20 06:47 AM | 61 | 67 | 57 | |
| 02/05/20 12:31 PM | 65 | 65 | 63 | |
| 02/05/20 05:09 PM | 63 | 58 | 63 | |
| 02/05/20 10:58 PM | 59 | 62 | 61 | |
| 02/06/20 03:43 AM | 51 | 59 | 58 | |
| 02/06/20 07:51 AM | 57 | 62 | 54 | |
| 02/06/20 11:12 AM | 63 | 50 | 51 | |
As you can see, there are multiple data sets that can span over a few different days, any hour of the day. I made a graph that contains all the data sets and currently the x-axis is formatted as text so that the labels appear as they do in the Date and Time column. So each label will be a random point and it will follow that format (include the date and the time). This formatting makes the x-axis look very cluttered as there are many data points. I'm just curious to know if there is a way that anyone knows of so that I can change the formatting of the x-axis so that its only time, but the date will appear below the times that occur on that date. I'm not sure how best to explain it, so I made a table in excel and I'll share the screenshot of what I'm imagining below.
First screenshot is what the formatting currently looks like (as you can see, its jammed together and kinda looks like a wall of text):
Here's my best artistic rendering (using excel tables) of what I'm wondering if I can change it to somehow within the table axis:
Basically, just groups all the times on a date then shows the data below just so its a little neater. Like I said, I'm not even sure if this is possible (and if not I'll just roll with my current format), but I'd figure I'd ask people who probably know a lot more about excel than I do!
Thanks for your help!
