Before we can even begin to create a diagram, of course, we need a data source from which the diagram is to be formed.
In our example, we have created a small table in which we have shown on the vertical axis 1 year (January – December), and on the horizontal axis fictional casinos with their monthly income.
In order to create a diagram from the available data, we proceed as follows:
- Mark the entire table
- Under the “Insert” tab, click the small arrow on the right in the “Diagrams” column to display all available diagram types
If you have a large table, you can mark it most quickly by placing it in the cursor in the 1st cell (top left), then holding down the “CTRL + SHIFT” key and then using the arrow keys on the keyboard 1x to the right , and then press down 1x.
This will only mark the area of a worksheet filled with content (without breaks).
See picture: (click to enlarge)