Changing a Chart’s Appearance

After you’ve created a chart, you can change any part of its appearance, including the chart’s type! If you display monthly sales data as a series of columns and decide that you would like to show the data as a line rising and falling as it moves from month to month, you can change the chart’s type at will. You can also change the color, font, and other properties of any chart element. If you want your chart’s title to be displayed in your company’s official font, you can format the title easily.

Change a Chart’s Type

  1. Click the chart you want to change.

  2. Click the Design tab.

  3. Click Change Chart Type.

  4. Click ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.