Format & Arrange:
Format Chart

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

Once you have created a chart, you are not locked into your choices forever. You can change everything about the chart. Excel 97/2000 has more chart types and formatting options than ever. Of course, if you have several changes, it might be faster to just start over.

The chart type determines the basic look of your chart - bar, column, pie, line, doughnut, etc. In addition the chart type will set font styles and sizes for titles and data labels, colors and patterns, gridlines, scale on the axes, and other features of your chart. The pre-defined chart types provide a very useful shortcut to chart design. You can customize any of features and save your design as a Custom type.

Commands for formatting charts are available on the Chart menu and on menus that popup with a right-click on chart parts. Sometimes it can be hard to click in the right spot to get the menu you want. Don't forget to use the Formatting bar for the basics. That's the easy way!



Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel BasicsTo subtopics   

Project 3: Format & ArrangeTo subtopics
    Format CellsTo subtopics
    Format Chart Open arrow to subtopics
    footprintPie Chart
    footprintColumn Chart
    ArrangeTo subtopics
    Error Values Table
    Compare Formats Table
    ExercisesTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Parts of a Chart

It might help to know the parts of a chart before you format one.

Plot area is where the data is actually pictured. 
Data series is the bars or dots or wedges that represent the values you are charting.
Data labels give the values for each bar or dot or wedge.
Axis is the vertical or horizontal for the chart.
Data table is a table of the values plotted on your chart.
Chart area includes the plot area, the titles, the data table, legend, and background.
Background is the color, pattern, or image behind the actual chart.
Titles include the title for the whole chart and titles for each axis.
Legend tells what the colors or pattens on the chart represent.

New for 97 Chart tips will popup to identify the part your pointer is over. A tip will even name the data series and gives the data point's value.

Chart - parts labeled