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. 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, pie, line, doughnut, etc.

Bar chartPie chartLine chartDonut chart
Area chart3D Line chartCone chart

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.

TipSometimes it can be hard to click in just the right spot to get the menu you want. 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 & Arrange
    Format CellsTo subtopics
    Format Chart Open arrow to subtopics
    footprintPie Chart
    footprintColumn Chart
    ArrangeTo subtopics
    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 try to format one. Some types of charts do not have all of these parts. For example, a pie chart does not have axes.

Chart - parts labeled

Plot area where the data is actually pictured
Data series the bars or dots or wedges that represent the values you are charting
Data label the value for a bar or dot or wedge, displayed near it on the chart
Axis the vertical or horizontal edge of the chart that is marked off in even lengths
Data table a table of the values plotted on your chart
Chart area includes all of the chart parts - the plot area, the titles, the data table, legend, and background
Background  the color, pattern, or image behind the actual chart
Titles the title for the whole chart and titles for each axis
Legend shows what the colors or patterns on the chart represent
Chart tips New for 97 a popup that identifies the part your pointer is over. A tip can name the data series and gives the data point's value.