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

j5jh.png


It will look something like this:
6c5x.png


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

Formatting a Graph

scgv.png


Adding a Title

uj5h.png


Adding an X-Axis Title

yjgr.png


Adding a Y-Axis Title

1lwq.png


Turning off the Legend

lv4g.png


Adding Grid Lines

1935.png


Adding Data Labels

djzt.png


Adding a Trend-line (Line of Best Fit)

p6s9.png


Changing the values on the X/Y-Axis

bkl8.png


pvv4.png


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

yx3s.png


Thanks for Reading :)
 
Status
Not open for further replies.
Status
Not open for further replies.