• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 24. Creating and Editing Charts > Secrets of the Office Masters: Creati...

Secrets of the Office Masters: Creating a Custom Chart Library

Why reinvent the wheel every time you create and format a chart? Build a library of good-looking custom charts, save them in your User-defined chart gallery, and call on them whenever you need them. The process is simple and straightforward:

  1. Start with a blank worksheet. Enter a basic table of dummy data, like the range shown here. (Note we've hidden gridlines and added formatting to the range, just to make the sheet look good.)

    Figure 24.21.

  2. Click anywhere in the worksheet outside the range you just created and click the Chart Wizard button. Breeze through the process of creating a basic column chart without any titles or additional formatting. Place this generic chart on the same sheet with your dummy data.

  3. Use the Clipboard to make three, four, or more copies of this chart, and arrange them on the sheet. Now you're ready to begin customizing.

  4. Right-click each chart in turn and set any or all of the following options:

    • Adjust the chart type if necessary.

    • Change the background colors for the chart area, plot area, fill area, gridlines, and data series. Choose a variety of complementary colors, including gradient fills and textures available when you click the Fill Effects button on the Patterns tab of the Format dialog box for each item.

    • Right-click the chart area, select Format Chart Area, and adjust the fonts for the entire chart. Then adjust the sizes of individual chart elements, such as axis labels and legends.

    • Add chart titles and adjust the size and position of each. Because the title is just a text box, you can move it anywhere, including inside the plot area. Don't be afraid to make extra copies of the basic chart and experiment with them.

    • If corporate policy dictates certain elements, such as logos or disclaimer text, add them to each basic chart design now.

  5. Save the workbook that contains the charts so you can reuse them any time. If you're certain you'll want to use one or more chart designs, add them to the User-defined chart gallery.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint