﻿ Excel Charts and Graphs Tutorial - How to Make and Create in Excel 2007
MS Office Training
 Excel Tutorial Excel Formulas Microsoft Word Training

Typing Training
 Typing Games For Kids Typing Tutorial Typing Test

Math Games
 Math Games Place Value Probability

Spelling & Vocabulary
 Spelling Games Crossword Puzzles Word Search

Grammar & Writing
 Learn English Grammar Creative Writing Course

Life Skills for Kids
 Good Study Habits Goal Setting Financial Literacy

Relaxing Mindfulness

Website Info
 Excel Basics Formulas & Functions Special Features Format Cells Sum, Average, Countif Functions Excel Charts (Graphs) Worksheets Quick Functions Excel Sort Edit Cells The IF Statement Excel Filter Rows and Columns VLOOKUP Function Conditional Formatting Find and Replace Sumif Function Pivot Table The Fill Handle Excel Formulas Create a Drop Down List Excel Keyboard Shortcuts First Aid

# Making Charts (Graphs) in Excel 2007 & Excel 2010

Here are 6 tutorial videos dealing with different aspects of Excel charts: How to make them, setting and locating relevant titles, relocating the legend (or hiding it), what are data labels and how to add them, how to rescale the Y-axis, and eventually giving them some style and touch with colors, fonts and backgrounds.
Creating a new chart (graph)
Relocating the legend
Rescaling the Y-axis
Formatting the chart
(colors, backgrounds, etc.)

When should you use a chart?
Use a chart whenever you want to visualize your data, making it clear and simple to comprehend. Sometimes one glimpse at a chart can save a lot of effort of figuring out the meaning of your data.

Last things to verify before creating a chart:
Make sure your data is organized in the correct layout:
- It should have a table layout, with no spaces between rows and columns, and no spaces between the headers and the rest of the table.
- When you select the chart’s data table, contain the headers in the selection, and don’t contain empty rows or columns.

Types of charts:
You can choose between many types of charts, the most popular are Column, Line and Pie.

The chart’s elements:

Titles:
You can add titles to the chart: a general title to the whole chart, and specific titles to the X-axis (the horizontal axis) and the Y-Axis (the vertical).

Legend:
The legend (which represents the meaning of the columns or lines) can be placed in any desired location around the chart, but can also be hidden.

Labels:
You can add small numbers to the columns, to show their exact values.

Y-axis scale:
You can set the Y-axis scale, and control the range of values depicted on it.
For example, on a chart comparing a \$33,000 car with a \$34,000 car, the difference will be much more salient if the Y-axis range is between \$30,000 - \$35,000 than that of a range of \$0 – \$35,000.

Formatting the chart’s elements (fonts, colors, backgrounds etc.):
Every element in the chart (titles, legend, columns etc) can be formatted as if it was a simple graphic object. All texts and numbers can be simply right-clicked and formatted with the mini-toolbar.