The Edit Series dialogue box then appears. This will allow you to add entries to the legend. Please select the Add button in the Legend Entries (Series) section of the Select Data Source dialogue box. Now, Right-click the line chart and choose Select Data from the menu that comes up. Next to the source data, enter the data point to be added to the chart.
Now, the chart is automatically populated upon selecting the above option. Click on Insert tool bar and select chart>Line>2-D Line to display the Line graph. Then, select the cells in the A2:B8 range. In the first, we must create a sample data for chart in an excel sheet in columnar format as shown in the below screenshot.
Let’s understand step by step with an example. Add a single data point in an excel line chart Now, only one data point must be added to an existing Excel line chart.
Excel makes it simple to combine two data series into a single chart.
0 kommentar(er)
