Yesterday, a colleague requested my assistance to modify an Excel chart. She has the following chart:

The data: (not the real data, of course :D)

She wanted to add another series of data for next year profit target:

So how do we incorporate the new row?

1. Add the new series.
   Right click on the chart, click ‘Source Data’
   Click Add button, and fill up the fields as indicated
2. Modify the series
   If you don’t have Chart toolbar as shown below, click View – Toolbars – Chart. If you already have it, select the newly created series.
   Change the chart type. Change the chart properties.

Final result: