I haven’t used this feature of spreadsheet software as much as I probably should, but I have a spreadsheet I have been working with a lot lately and conditional formatting…
Continue reading
I haven’t used this feature of spreadsheet software as much as I probably should, but I have a spreadsheet I have been working with a lot lately and conditional formatting…
Continue reading
In a different post on this blog, I showed how to use Vlookup to match lists. Someone commented on that post and indicated that it didn’t work with dates. It…
Continue reading
As a scholar who regularly publishes work with charts and graphs, I’m often confronted with varied requirements from publishers for the format in which they want the charts and graphs….
Continue reading
While a bit technical, it’s occasionally useful to plot multiple data series that have very different scales in the same chart. Let me give an example to illustrate. Let’s say…
Continue reading
Here’s my situation. I have some data over time but I’m missing values in specific years. I want to graph that data but would rather not have to estimate all…
Continue reading
I was working on creating a chart in LibreOffice Calc that was kind of weird. Basically, I wanted to show change over time in a dichotomous variable (e.g., political party…
Continue reading
One of the tasks I have to do regularly as part of my job is to compare two lists to see which items are missing on one list but not…
Continue reading
I periodically have to take a column of text in LibreOffice calcĀ that has names like this “Lastname, Firstname” and split them into two columns. I figure it out every time,…
Continue reading