natspot.blogg.se

• #OPENOFFICE CALC GRAPH LINE OF BEST FIT SERIES#

The graph has to be more intuitive, so I will change the format of the axes. Given my total ignorance, I am going to attribute it to the Calc display: the blue line is somewhat blurred, but it is quickly solved as soon as we adjust the size of the graph: Like everything done so far, it can be modified later.Īlthough Libreoffice has advanced a lot compared to its predecessor OpenOffice, the treatment of the graphics is still something that could be improved (and that is already much better than it was). Graphic elementsįinally, in this last step we can adjust the aesthetics of the graphic. In the case of my Calc file (.ods), the data is in the sheet named «UsemosLinux», the X and Y values ​​being cells 3 to 1002 of column K and J respectively. $ column $ start cell: $ column $ end cell In order not to eternalize us lowering cells, we will specify it manually following the nomenclature: $ sheetname. To select the desired range of X or Y values, we can press the box on the right, which will minimize the dialog box and allow us to select the boxes manually. In my case, I have called them a, b and c, following the order of quadrants that I mentioned above.

#OPENOFFICE CALC GRAPH LINE OF BEST FIT SERIES#

Our graph will represent by lines each one of the data series defined in this step. For the sake of simplicity we are going to skip this step (it is not essential to create the graph).

This data range can contain multiple sections of the same worksheet. As I mentioned earlier, we can pre-select the regions of our datasheet that we want to plot. If we click on 'next', the wizard allows us to select the "data range" with which we are going to work. In my case, I will create an XY scatter plot with smoothed lines, given the large number of points present in my plot. At (X> 0, Y

In (X 0) I will represent Y versus X-1.At (X> 0, Y> 0) I will plot column Y versus X.

My intention is to create an XY type graph in which I will use 3 quadrants: I have also divided the sheet horizontally to see the data at all times (left) while I also have the section where I will insert the graph (right) accessible. Here you can see how I have prepared the columns with their header.