- #How to graph line chart with microsoft excel 2011 for mac#
- #How to graph line chart with microsoft excel 2011 series#
#How to graph line chart with microsoft excel 2011 series#
Add a data series to a chart on a chart sheet In that case, you can enter the new data for the chart in the Select Data dialog box. If your chart is on a separate chart sheet, dragging might not be the best way to add a new data series. The chart is updated automatically and shows the new data series you added.
On the worksheet, drag the sizing handles to include the new data. The source data is selected on the worksheet showing the sizing handles. On the worksheet, in the cells directly next to or below the source data of the chart, enter the new data series you want to add. If your chart is on the same worksheet as the data you used to create the chart (also known as the source data), you can quickly drag around any new data on the worksheet to add it to the chart. The new data series appears under Legend Entries (Series) in the Select Data Source dialog box.Ĭlick OK to close the dialog box and to return to the chart sheet.Īfter creating a chart, you might add another data series to your worksheet that you want to include in the chart. Leaving the dialog box open, click in the worksheet, and then click and drag to select all the data you want to use for the chart, including the new data series. The Select Data Source dialog box appears on the worksheet that contains the source data for the chart. Right-click the chart, and then choose Select Data.
On the worksheet that contains your chart data, in the cells directly next to or below your existing source data for the chart, enter the new data series you want to add.Ĭlick the worksheet that contains your chart. In that case, you can enter the new data for the chart in the Select Data Source dialog box. If your chart is on a separate worksheet, dragging might not be the best way to add a new data series.
Notes: If you just want to show or hide the individual data series that are displayed in your chart (without changing the data), see:Ĭhange the data series in a chart (Office 2013)Ĭhange the data series in a chart (Office 2016)Īdd a data series to a chart on a separate chart sheet If your chart is on a separate sheet, you'll need to use the Select Data Source dialog box to add a data series. A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits.Ĭharts in Office are always associated with an Excel-based worksheet, even if you created your chart in another program, such as Word. LessĪfter creating a chart, you might need to add an additional data series to the chart.
#How to graph line chart with microsoft excel 2011 for mac#
Excel for Microsoft 365 Word for Microsoft 365 PowerPoint for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Excel 2021 Word 2021 PowerPoint 2021 Excel 2021 for Mac Word 2021 for Mac PowerPoint 2021 for Mac Excel 2019 Word 2019 PowerPoint 2019 Excel 2019 for Mac Word 2019 for Mac PowerPoint 2019 for Mac Excel 2016 Word 2016 PowerPoint 2016 Excel 2016 for Mac Word 2016 for Mac PowerPoint 2016 for Mac Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Excel Starter 2010 More.