How to use Excel to make a simple and beautiful profit and loss chart

How to use Excel to make a simple and beautiful profit and loss chart

For example, columns B and C are sales figures for 13 and 12, respectively, and the D column calculates the difference between the two sets of data, as shown in the following simulated sales data sheet.

In this table, can you quickly see the difference in data each month and the trend of variance over the past year?

Let's look at how we can use graphs to show the difference in data:

First, create a secondary column in the e column, E2 input formula

=d2

Copy the formula down.

Select the e-column data range and set the conditional formatting as shown in the following figure:

When you are finished setting: