O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Meaningful Charts

Sometimes it is useful to display data in a chart instead of in a table. In Excel 2007 and Excel 2010, the options for creating bar charts, pie charts, and other charts have been enhanced.

Creating a Column Chart

To convert our example table into a simple but informative column chart, perform the following steps:

  1. Select the table cells starting from Month to the profit margin December (see Figure 1-38).

    Selecting a value to create a chart.

    Figure 1-38. Selecting a value to create a chart.

  2. On the Insert tab in the Chart group, click the Column button and select the first chart under 2D Column (see Figure 1-39).

    Figure 1-39. Selecting the chart format.

    The chart is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required