Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

To include the legend indicated in the graph that displays the cumulative moving average forecast, follow these steps:

  1. Select the graph or chart.

  2. Click on the "Chart Elements" button (it looks like a plus sign) in the upper-right corner of the chart.

  3. Check the box next to "Legend" to add a legend to the chart.

  4. Click on the "Legend" drop-down menu and select "More Legend Options."

  5. In the "Format Legend" pane that appears on the right-hand side of the screen, you can customize the legend's appearance and location.

  6. In the "Legend Entries (Series)" section, you can add, remove, or rename the series on the chart.

  7. To add a series to the legend, click on the "Add" button at the bottom of the section.

  8. In the "Edit Series" dialog box that appears, enter the name of the series in the "Series Name" field.

  9. Select the cells containing the data for the series in the "Series Values" field.

  10. Click "OK" to close the dialog box and add the series to the legend.

  11. Repeat the process for each series on the chart that you want to include in the legend.

  12. Once you have finished customizing the legend, click anywhere outside of the "Format Legend" pane to close it.