Format & Arrange:
Format Column Chart

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

Column charts are good at showing how the data points relate to each other. It is much easier to see how each column compares to the others than it is to compare the wedges of a pie chart.

A column chart has more features than a pie chart does. You have more parts to play with!

Sample - Column Chart

Sample Column Chart

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


Icon Step-by-Step 

Step-by-Step: Format Column Chart

 Icon Step-by-Step

What you will learn:

to change chart type
to set chart options

Start with: Class disk trips15.xls (saved in previous lesson)

Format Chart: Chart Type

  1. Dialog: Chart Type - stanadard typesRight click in a blank area of the chart and choose  Chart Type…  from the popup menu. The Chart Type dialog opens.
  2. Select Column, which is Excel's default chart type, and choose the first sub-type.
  3. Click OK.

    Chart: Column typeThe chart is redrawn as a set of columns, using the default settings for this chart type. The data points are now labeled with the values they represent instead of the percentages.

    The 18% wedge for Week 2 now is labeled 23 but it retained the pattern you assigned to it. All the other wedges are converted to the default dark red columns. The legend does not accomplish much in this case. You will get rid of it shortly.

    Since Week 2 had the highest number of tickets sold, it actually works well to have it's column a different color from the rest.

Format Chart: Chart Area

The blank background is good for many charts, but sometimes a pattern or image can help.

  1. Popup Menu: Format Chart AreaRight click in a blank area of the chart and choose  Format Chart Area…  from the popup menu. The Format Chart Area dialog opens, with tabs for Patterns, Font, and Properties.
  2. On the Patterns tab, click on the Fill Effects button. The Fill Effects dialog opens with tabs for Gradient, Pattern, Texture, and Picture. Experiment with some of the choices.
  3. Click on Picture and on the Select Picture button.
  4. File name text box c:\windows\clouds.bmpIn the File name text box type:
    Icon: Win98  c:\windows\clouds.bmp .

    Or you can browse to find another picture to use. The paths are to files that are backgrounds that comes with Windows, if you installed to the folder Windows.

    If you don't find one of these files on the hard disk, use some other picture or use one of the choices on the Texture tab of the dialog. A light color will work best.)

  5. Dialog: Fill Effects with clouds.bmpClick OK to close the Fill Effects dialog.
  6. Click OK again to close the Format Chart Area dialog.

    Your chart now shows the clouds image as a background. Much prettier than a plain white background! Of course a busy or dark image could make it hard to read your chart.

    Chart: Columns with clouds  background

Format Chart: Chart Options

  1. From the menu select  Chart  |  Chart Options…  The Chart Options dialog opens with 6 tabs. Check out the various options on each tab. Choice, choice, choices.
  2. Click on the tab Legend and uncheck the box for Show legend. This particular chart is not helped by a legend. (You could have clicked the legend on the chart to select it and press DELETE.)
  3. Dialog: Chart Options - Titles tabClick on the tab for Titles.
  4. In the text box for Chart title, edit the title to read  Number of Tickets Sold , which explains the chart better.
  5. In the text box for Category (X) axis, type  Weeks of Special Offer 
  6. Click on OK.
  7. Rename the Pie Chart sheet as  Tickets Sold Chart  (Hint: Right click on sheet tab and choose Rename or double-click the tab and type.)
  8. Deselect the chart by clicking off the chart.
  9. Open Print Preview. (File | Print Preview)
    The preview is not in gray scale, even if the printer is set to print that way.  This makes it hard to be sure what the printed page will look like.
  10. Preview: trips15.xls

    Print Preview

    Preview: trips15.xls in grayscale

    Print-out in gray scale

  11. Save Save as  trips16.xls  on your Class disk in the  excel project3  folder.
  12. Print Print the sheet. Printing in color is certainly prettier for this one.