Excel Level-Up: Day 8

Plotting Graph

Are you being traumatized from your past graph plotting experience?

Today, we are going to show you an error-proof graph plotting trick. It is a very simple trick that rectifies mistakes that most of us do when plotting graph.

Do you always construct your table in this way when you plot your graph? 

If so, you are most likely to have to adjust for the axis label and will have to remove the “Year” column manually.

Here is our trick, in order for the graph to pop out nicely, REMEMBER, to let the left-upmost cell to be EMPTY. So, if you just clear that cell and re-plot your graph, it will fall out just nicely.

It is as simple as that.


Go back to previous awesome trick: Excel Level-Up: Day 7
Proceed to next awesome trick: Excel Level-Up: Day 9