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.