How to Display Series Names Directly on Chart Lines in Excel
Question details
The user wants to display data series names directly on chart lines to avoid relying on a traditional color-coded chart legend.
- Product
- Microsoft Excel / WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- Formatting a line chart to make data identification faster and more intuitive for viewers without needing to cross-reference a separate legend.
- Observed behavior
- By default, chart series are identified using a separate legend box. The goal is to attach a label displaying the series name directly to the specific data line.
Ensure your line chart is already created and populated with multiple data series so you can accurately select the specific endpoints for labeling.
Add Data Labels to Specific Chart Points
Use the built-in 'Add Data Label' feature to attach a series name to a single point on the chart line, keeping the visualization clean.
Applying a data label to an entire series will clutter your chart with text at every data point. To achieve a clean look similar to direct line labeling, you should isolate a single data point (usually the last point on the right) and apply the series name exclusively to it.
Click on your existing chart, then single-click the specific line for the desired data series to highlight the entire line.
Click again on the final data point of that specific line. You should now see selection handles only on that single point.
Right-click the selected data point and choose 'Add Data Label' from the context menu. A number (the data value) will appear.
Right-click the newly added label and select 'Format Data Label'. In the formatting pane, check the 'Series Name' box and uncheck the 'Value' box. Set the Label Position to 'Right' or 'Above' for best visibility.
Easily Add Labels to Chart Lines in WPS Spreadsheet
WPS Spreadsheet offers an intuitive and free way to format charts, add custom data labels, and manage series names, ensuring a streamlined workflow and seamless compatibility with all your existing workbooks.
- 1. Open your Workbook in WPS Spreadsheet: Launch WPS Office and open your .xlsx file containing the line chart.
- 2. Select the Target Chart Point: Click on the line chart, then double-click the final point of the series line you want to label so that only one point is selected.
- 3. Insert the Series Name: Right-click the point, select 'Add Data Labels', then click the 'Chart Elements' icon to format the label to display only the Series Name.
Frequently Asked Questions
Why is the data label showing a number instead of the series name?
By default, spreadsheet software adds the numerical 'Value' to a new data label. You need to right-click the label, choose 'Format Data Label', check the 'Series Name' box, and uncheck 'Value'.
Can I apply the series name to the entire line at once?
If you add data labels to the entire series, a label will appear at every single data point. To keep the chart clean and readable, it is recommended to select just one data point (usually the last one) to display the series name.
Will these line labels update if I change the series name in my data?
Yes, as long as the data label is linked to the series name in the formatting options, any changes made to the series header in your source data will automatically update on the chart.
How do I remove the default chart legend after labeling lines?
Click on the default legend box at the bottom or side of your chart and press the Delete key on your keyboard, or uncheck 'Legend' from the Chart Elements menu (the plus icon next to the chart).
