Tag: LibreOffice Calc charts

  • LibreOffice – exporting high-resolution TIFF/TIF files

    LibreOffice – exporting high-resolution TIFF/TIF files

    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. Most often, the format is as a TIFF/TIF file, typically with at least 300 dpi and somewhere around 1500×1500 pixels. I make most of my…

  • LibreOffice Calc: Graphs with Two y-axes with Different Scales

    LibreOffice Calc: Graphs with Two y-axes with Different Scales

    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 I want to see whether the number of Mormon temples being built aligns with the number of Mormon stakes (akin to a Catholic diocese) that…

  • LibreOffice Calc: Interpolating Missing Values in Graphs

    LibreOffice Calc: Interpolating Missing Values in Graphs

    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 of the missing values. It turns out, LibreOffice Calc can do that for you in your chart. Here’s how… Imagine I’m plotting the number of…