Change data label to be date instead of sequential numbering

asked 2020-03-22 17:44:17 +0200

Vigilance gravatar image

updated 2020-03-22 17:48:58 +0200

I'm trying to make a special spreadsheet, where I need data to be displayed sequentially, but all the data is grouped in pairs of two. So basically, I'm taking in two data points per day, but I don't want them to be displayed on top of each other like the right side of the picture shows, I need them displayed side by side like the left side of the picture. However, I ALSO need it to be labeled with the date, like the right side of the picture. How can I get the best of both worlds?

Edit: Forgot the picture!

Picture Picture

edit retag flag offensive close merge delete


If it is the data from the same source but separated by time then you would need to add the time as well (format DD/MM/YY HH) to column A to get horizontal separation.

If the second data point of the day is from another source than it should be in a different column. That way you would get a different colour for it although they would still be one above the other because it is still the same point on the horizontal axis.

Cheers, Al

Earnest Al gravatar imageEarnest Al ( 2020-03-22 21:58:29 +0200 )edit