Scatter plot in excel mac 2011

Click the "Legend" button to display the Legend drop-down menu, and then click the button corresponding to where in your chart you want to insert the legend.

Create a scatter chart

Andrew Tennyson has been writing about culture, technology, health and a variety of other subjects since Skip to main content. Load the Excel worksheet containing the chart you want to edit.

How to Make an Excel Chart in Office for Mac - dummies

Click the chart into which you want to insert a legend. Click the "Charts" tab on the ribbon to load the Charts group. Tip Excel automatically inserts a legend with default formatting at your selected location in the chart. You can then format the legend's font and change its location via the Legend Options panel. To access the Legend Options panel, start by clicking your chart to select it. Click the "Charts" tab on the ribbon, click "Chart Layout," click the "Legend" button, and then click "Legend Options" to load a list of customizable options for your legend. Click the "Font" tab to customize the font.

Create a chart in Excel for Mac

Click the "Placement" tab to change where the legend appears on the chart. Warning Information in this article applies to Excel for Mac. It may vary slightly or significantly with other versions or products.


  • disk read write speed test mac.
  • Was this information helpful?.
  • customer service management software for mac!

References 3 Microsoft: I did it with the given data in Excel for Mac. Select the whole table all four columns and create a scatter plot.

It will add two data series, so right-click on the data series and "Select Data", then manually select the X and Y columns for the data series. Delete the other one.


  • easy recipes baked mac n cheese?
  • mac os file system pdf.
  • Video of the Day.
  • Getting Started.
  • Thank you for your feedback!.

Then right click on the data series and add labels. Then right-click on the labels and Format Data Labels. In the dialog box, I had to uncheck "Y value" and check "X value". It still reads the X value from columns A and B. Damn, it didn't work when I tried to repeat it. Ah, add the data labels before manually selecting the X and Y columns.

Unfortunately, that method's not working for me, supercres.

About scatter charts and bubble charts

When I manually select the data series columns, the labels change to the new selection. And the Visual Basic thing didn't work for me either which is not surprising, since I have no knowledge of how visual basic works. This is a very common problem and it's not really solvable without VBA. If you're having trouble with the code, here's a free utility that does it for you: I think what I'm going to do is make each category its own series and then sigh manually label the names.

The categories have few enough entries that doing it that way will at least make it faster to identify which datapoint is which. You can do something like this with Google Docs. Here's an example, "AskMe ". If you are open to it, Google Spreadsheet may help.