I’ve recently run into a couple of problems with trying to make charts in Calc. It is trivial to do this in Google Sheets, but I want to do this with local files.
I export glucose readings in a csv file to either Calc or Google Sheets when I get nowhere with Calc. One column is the date and time of day. The csv file comes through in descending order and I want the dates in ascending order to see progress over time. In Calc, the data sorts with the month and then the first number of the date. So the 21st day comes before the 5th day. In other words, out of order. I have not checked to see what order the time is sorted in. One approach that I thought would work is to just reverse the entries on the sheet for charting, but I can find no way to do that either.
Similarly, I added a column with one of three possible entries: morning, noon or night. I wanted to see three bars for each date. Instead, I get 3 labels at the bottom of the bar but only one data point. Calc may not do sophisticated charting like Excel, but it should be able to do this. Are there add-ons that will accomplish these things?