That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work.Voilà! Your chart is ready, showing both the number of shoes sold and percent, according to shoe size.
Select the first line graph option that appears, as shown below. There’s a box-and-whisker in the center, and it’s surrounded by a centered density, which lets you see some of the variation. Next, click on the column in the chart which contains the values for the line chart. In such case you have to create the combination of the two chart types manually: First set up a normal stacked column chart with all the data in it (also the data for the line chart).