How do I add series name in Excel chart?

Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Series name box, type the name you want to use.

How do I label a series in an Excel line graph?

In Microsoft Excel, right-click on the data point on the far right side of the line and select Add Data Label. Then, right-click on that same data point again and select Format Data Label. In the Label Contains section, place a check mark in either the Series Name or Category Name box.

How do I show series options in Excel chart?

Select the chart element (for example, data series, axes, or titles), right-click it, and click Format <chart element>. The Format pane appears with options that are tailored for the selected chart element. Clicking the small icons at the top of the pane moves you to other parts of the pane with more options.

How to show Series name in Excel chart

In this tutorial, we’ll show a Bar Graph comparing items sold for two different products by month. Let’s say instead of showing Product A and Product B on the graph, you want to show the actual series on the graph.

Índice Show

Add a data series to a chart on the same worksheet
Add a data series to a chart on a separate chart sheet
Add data labels to a chart
Change the look of the data labels
Use cell values as data labels
How do I add series name in Excel chart?
How do you add a series name to a chart?
How do I label a series in an Excel line graph?
How do I show series options in Excel chart?

Is there a way to make the reverse value of axis order dynamic? Thanks to all these great blog entries, I have a dynamic chart that displays different data based on a pulldown option (counts or amounts). Counts display in the helper table as positive integers, and amounts display as negative decimals, with custom format to display as currency.

When I graph the data, the vertical axis shows proper logical stacking (0 upward to high value) for the counts, but amounts descend from the top (0) down to the low maximum (-$1M). If I choose inverse order when graphing the amounts, switching back to counts now shows the counts descending from the top of the chart.

I'd like to only invert the order when the pulldown reads "amounts" (or values are negative). Negating the helper table values can be troublesome, since I use the negative amount to format the vertical axis (positives display as integers, negatives display as currency).

After creating a chart, you might need to add an additional data series to the chart. 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.

Charts in Office are always associated with an Excel-based worksheet, even if you created your chart in another program, such as Word. 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. If your chart is on a separate sheet, you'll need to use the Select Data Source dialog box to add a data series.

WindowsMacOS



Note: If you're looking for information about adding or changing a chart legend, see Add a legend to a chart.

Add a data series to a chart on the same worksheet

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.

In this example, we have a chart that shows 2013 and 2014 quarterly sales data, and we've just added a new data series to the worksheet for 2015. Note that the chart does not yet display the 2015 data series.
Click anywhere in the chart.
The currently displayed source data is selected on the worksheet, showing sizing handles.
You can see that the 2015 data series is not selected.
On the worksheet, drag the sizing handles to include the new data.
The chart is updated automatically and shows the new data series you added.

Notes: If you just want to show or hide the individual data series that are displayed in your chart (without changing the data), see:

Change the data series in a chart (Office 2013)
Change the data series in a chart (Office 2016)

Add a data series to a chart on a separate chart sheet

If your chart is on a separate worksheet, dragging might not be the best way to add a new data series. In that case, you can enter the new data for the chart in the Select Data Source dialog box.

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.
Click the worksheet that contains your chart.
Right-click the chart, and then choose Select Data.
The Select Data Source dialog box appears on the worksheet that contains the source data for the chart.
Leaving the dialog box open, click in the worksheet, and then select all data you want to use for the chart, including the new data series.

To quickly identify a data series in a chart, you can add data labels to the data points of the chart. By default, the data labels are linked to values on the worksheet, and they update automatically when changes are made to these values.

WindowsmacOS



Data labels make a chart easier to understand because they show details about a data series or its individual data points. For example, in the pie chart below, without the data labels it would be difficult to tell that coffee was 38% of total sales. Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point.

Note: The following procedures apply to Office 2013 and newer versions. Looking for Office 2010 steps?

Add data labels to a chart

Click the data series or chart. To label one data point, after clicking the series, click that data point.
In the upper right corner, next to the chart, click Add Chart Element
> Data Labels.
To change the location, click the arrow, and choose an option.
If you want to show your data label inside a text bubble shape, click Data Callout.

To make data labels easier to read, you can move them inside the data points or even outside of the chart. To move a data label, drag it to the location you want.

If you decide the labels make your chart look too cluttered, you can remove any or all of them by clicking the data labels and then pressing Delete.

Tip: If the text inside the data labels is too hard to read, resize the data labels by clicking them, and then dragging them to the size you want.

Change the look of the data labels

Right-click the data series or data label to display more data for, and then click Format Data Labels.
Click Label Options and under Label Contains, pick the options you want.

Use cell values as data labels

You can use cell values as data labels for your chart.

Right-click the data series or data label to display more data for, and then click Format Data Labels.
Click Label Options and under Label Contains, select the Values From Cells checkbox.
When the Data Label Range dialog box appears, go back to the spreadsheet and select the range for which you want the cell values to display as data labels. When you do that, the selected range will appear in the Data Label Range dialog box. Then click OK.

How do I add series name in Excel chart?

Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Series name box, type the name you want to use.

How do you add a series name to a chart?

Add data labels to a chart.

Click the data series or chart. ... .

In the upper right corner, next to the chart, click Add Chart Element. ... .

To change the location, click the arrow, and choose an option..

If you want to show your data label inside a text bubble shape, click Data Callout..

How do I label a series in an Excel line graph?

In Microsoft Excel, right-click on the data point on the far right side of the line and select Add Data Label. Then, right-click on that same data point again and select Format Data Label. In the Label Contains section, place a check mark in either the Series Name or Category Name box.

How do I show series options in Excel chart?

Select the chart element (for example, data series, axes, or titles), right-click it, and click Format <chart element>. The Format pane appears with options that are tailored for the selected chart element. Clicking the small icons at the top of the pane moves you to other parts of the pane with more options.