|
 How
to use data from a table to create a graph chart in excel
If you have a presentation or
a project to do, creating a graph chart from your collected data can make your
work look extremely professional. Just say you have some figures in a Excel
table and you want to present it more clearly or make them visually eye
catching. This is when you need to insert or create a graph by using the data
from that table. A graph not only looks better and is more presentable, but it
also helps others process the data easily. A bar graph is the most common graph
chart to use, and therefore we will use this one in our example.
Here is a quick example of a table containing
data. See the screenshot below. Now I will show you how to make this data look
great by creating a graph.
.JPG)
How to use your table data to make a graph chart in
Excel?
- Open Excel. Create a table with data or open an existing file.
- Then select it all by
holding and dragging your mouse over the table. See the screenshot below.
.JPG)
- Next go to too the top of the excel window
and along the top there are the headings ‘Home’, ‘Insert’, ‘Page
Layout’, ‘Formulas’, ‘Data’, ‘Review’ and ‘View’.
- Click on Insert tab
- Now click on the type of graph you would
like to insert. (E.g. Bar graph, Column graph, Pie graph and Line graph) See
the screenshot below.
.JPG)
-
Once you have selected the type of
graph it will appear next to your data. See the screenshot
below. Now you have a new graph chart that shows your data from the table.
.JPG)
There is no denying that this data from the
table looks better in a graph chart layout. Tables are boring!
How to customize a graph chart in Excel 2007?
-
If
you right click on the whole graph.
A menu will appear.
Select Format Chart Area
from the menu. It is a link on the bottom of the menu. See the screenshot
below.
.JPG)
-
The Format Chart Area
Window will appear.
-
Then you can change the colours and
headings to your preferences. See the screenshot below.
.JPG)
How many graph charts are available in Excel 2007?
There are too many graph charts to mention them all,
however you can see them for yourself.
- Go to the insert menu tab or ribbon.
- Choose Other Charts from the menu. See
screenshot below.
- A drop down menu will appear. Choose the
link that says chart types at the bottom.
- The following Window will appear with all the graph chart types
available. See the screenshot below.
How to
merge cells in excel
Change UPPERCASE text to lowercase in Word 2007
How to enable or
show the developers tab in Microsoft Word 2007
How to embed a Youtube video into a PowerPoint Presentation
Embed Youtube video into a PowerPoint 2007 presentation CD.
How to save a word 2007 document to be compatible with Word
97-2003
Add shortcut icons to your Quick Access toolbar in
Microsoft Word 2007
How to save a picture,
logo, or clip art from a word document?
Select all text with a similar format style in word 2007 document
How
to make headings and titles in a word 2007 document?
How to link
to a heading, title or bookmark in a word 2007 document
How to make a
bookmark in a word 2007 document?
Add a video or to
word 2007 and convert it to a PDF
Add a watermark
to your Word 2007 document
Shortcut to
delete all html hyperlinks from a Word document
About the Author
Jarrah Mclardy wrote this article and others for
tips4pc.com Browse
for more articles that are written in an easy to understand
way. Also see our very popular
Video Tutorials page. Watching
a video is a very easy way to learn about computers.
I hope you've found this tutorial clear and easy to
understand. If you have more questions, feel free to visit our
FORUM and we'll be
happy to help.
Get the Tips4pc newsletter
| 
