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 :)
 
Status
Not open for further replies.
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
Q Apps General Discussion 2
V Apps General Discussion 2
C Apps General Discussion 3
PepeTheDog Apps General Discussion 3
S Apps General Discussion 6
A Apps General Discussion 5
T Apps General Discussion 1
S Apps General Discussion 4
T Apps General Discussion 1
M Apps General Discussion 1
M Apps General Discussion 1
R Apps General Discussion 1
M Apps General Discussion 2
G Apps General Discussion 1
M Apps General Discussion 2
C Apps General Discussion 4
A Apps General Discussion 1
D Apps General Discussion 4
J Apps General Discussion 11
thegamersite1 Apps General Discussion 1

ASK THE COMMUNITY