Master Excel with Formula-Driven Graphs

Getting these two chart types in your Excel sheet is surprisingly easy, it just requires a little trick that you might not have learned about. In both the line chart and the doughnut chart we're plotting two series in the same chart and editing them separately. In the line chart example we've just combined a line chart and area chart that use the exact same data. In the doughnut chart we've just plotted two identical doughnut charts and then increased the transparency of all the colors in the ou