Friday, 17 June 2016

Excel Level-Up: Day 9

No more default graph

Does your chart always look like this?


While it is quick and easy to produce, it shows you as an Excel amateur too. Worse, this graph tells us that you are too lazy to bother about formatting it into a nicer/tidier chart.

As people judge you from your graphs (we all know they should not, but in reality, they do!), it is worth spending some time upgrading our graphs. 

In the minimum, please,
Step 1: Remove grideline
Step 2: Move your legend to the bottom, to maximize the graph area
Step 3: Label your axis
Step 4: Remove tick marks on the axis
Step 5: Change the texture of your graph and the colour of the fonts.



How do you feel about your graph now?

Go back to previous awesome trick: Excel Level-Up: Day 8
Proceed to next awesome trick: Excel Level-Up: Day 10

No comments:

Post a Comment