Open In App

How to Add Lines In An Excel Clustered Stacked Column Chart?

Improve
Improve
Like Article
Like
Save
Share
Report

In Excel, a chart is a tool you may use to visually convey data. Charts are used in Microsoft Excel to provide a graphical representation of any set of data. Scientific, statistical, and technical data are frequently represented and compared using scatter plots. There are two Value Axes in a Scatter chart: a Vertical (y) Value Axis and a Horizontal (x) Value Axis. It creates a single data point by combining the x and y values and presents them in clusters or erratic intervals. Place the data in columns and rows on the spreadsheet to make a scatter chart.

Creating a Stacked Column Chart

Step 1: First create a table in excel.

creating-table

 

Step 2: Select the table. Navigate to the insert tab on the top of the ribbon then go to the charts group and select the 3-D column bar chart.

selecting-3-D-column-bar-chart.

 

Step 3: Now as you can see 3-D column bar chart is created.

3-D-column-bar-chart-created

 

Steps to Add a Line in a Stacked Column Chart

Step 1: First we need to add a new column to an existing table. Here we are adding the June column.

adding-June-column

 

Step 2: Select the existing chart. Navigate to the chart design tab on the top of the ribbon and then in the data group choose the select data option.

selecting-data-option

 

Step 3: Then a select data source dialog box appears. Here in legend entries click on Add.

legend-entries

 

Step 4: Edit Series dialog box appear. Here select the series name and series values and then click on OK.

Edit-Series-dialog-box

 

Step 5: It adds the June column to the existing 3-D stacked column chart. Now we need to convert this June stacked column chart to the line chart.

June-column-added-to-existing-3-D-stacked-column-chart

 

Step 6: Select the June series and then right-click on it. Choose the change Series Chart Type option.

Choosing-change-Series-Chart-Type

 

Step 7: Change Chart Type dialog box appears. Here in the June chart type select line chart.

Changing-Chart-Type

 

Step 8: Now you can see it converts the stacked chart into a line chart.

stacked-chart-converted-into-a-line-chart

 


Last Updated : 23 Jan, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads