How to Create a Graph in Excel and Properly Format It

How to Create a Graph in Excel and Properly Format It

Introduction
This tutorial will teach an individual how to create a basic graph and format it properly. Please note that the data used in this tutorial is all made up.

Creating the Graph



It will look something like this:


This doesn't look detailed enough so we are going to start the formatting part of this tutorial.

Formatting a Graph



Adding a Title



Adding an X-Axis Title



Adding a Y-Axis Title



Turning off the Legend



Adding Grid Lines



Adding Data Labels



Adding a Trend-line (Line of Best Fit)



Changing the values on the X/Y-Axis





Recap
This is what our end result looks like after doing all the formatting as well as playing with the colors



Thanks for Reading