Go back to the main page

Excel plotting for Mac users

---

Excel plotting

Herewith some screenshots for creating Microsoft Excel plots om a Mac. The OS version used was 15.3.1 (Sequoia).
Office version: 16.95.3

Dataset used can be accessed here.

Data was loaded using PowerQuery. Category filtered was: Breakfast.

First start with creating a clustered column graph.

Insert > Clustered Column

_{Figure 1. Insert clustered column graph.}

Press the + sign to add a dataseries.

_{Figure 2. The first series is added.}

Now select the y-values from the menu sheet:

_{Figure 3. Remove text from selection box.}

Note: remove any text in the selection box!

_{Figure 4. Text removed from selection box.}

Select the data range calories.

_{Figure 5. Data range selected.}

The series is now added:

_{Figure 6. The selection is added to the first series.}

Now add the second series:

_{Figure 7. The second series is added.}

Now select the second data range calories from fat on the menu sheet and add it to the series.

_{Figure 8. The second series is added.}

Now the second series is selected.

_{Figure 9. The selection is added to the second series.}

Add the horizontal category axis labels:

_{Figure 10. The horizontal axis labels are selected.}

Now click on OK and your graph will be displayed.

_{Figure 11. The clustered column graph result.}

Sometimes you will encounter some warnings. In most cases this can be resolved by removing anything from the selection box.

---

Go back to the main page
⬆️ Back to Top

---

This web page is distributed under the terms of the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited. Creative Commons License: CC BY-SA 4.0.