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.

 

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.

 

Step 3: Now as you can see 3-D column bar chart is 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.

 

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.

 

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

 

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

 

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.

 

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

 

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

 

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