|
Changing the appearance of the
chart There are so many parts of the
chart, plot area, titles, axes etc that you can change. Here is a small
sample. As always, it's best to have a bit of a play. You may spend an hour or
so mucking about with all the features but it is time well spent. Once you know the
sorts of things you can change and how to do it your productivity will go up very
quickly. Do play around with the fill effects options - add textures, pictures and
so on. Have fun!
|
| Format Chart Area Click the chart. Click the right mouse button and
choose Format Chart Area.
- Change the colour of the chart…use a Fill
Effect if you like.
- Choose Round Corners and/or Shadow if
you like.
Change the Border if you like |
|
| Format Plot Area Click the plot area of the chart. Click the right mouse
button and choose Format Plot Area.
- Change the colour of the plot area…use a Fill
Effect if you like.
Change the border if you like.
|
|
| Format Axis/Title Area Click a title or axis title on the chart. Click the right
mouse button and choose Format Title Area.
- Change the Pattern, Font or Alignment of
the title you have chosen.
- Use a Fill Effect if you like.
Change the border if you like. |
|
| Format Data Series Click a data series on the chart. Click the right mouse
button and choose Format Data Series.
- Change the Patterns of the lines and markers
of the data series you have chosen.
- Use a Fill Effect if you have chosen a column
series.
- Change the border if you have chosen a column
series.
Play with the options that are available. You can
have a lot of fun choosing various options. |
|
| Chart Options Click the chart. Choose Chart | Chart Options on the
toolbar (or click the right mouse button).
Type a title for the chart and the title for each
axis in the appropriate slot then click OK. |
|
| Position of the legend Click the legend box on the chart. Choose Format |
Selected Legend on the toolbar (or click the right mouse button).
Choose Placement and choose one of the
options - say, bottom — and click OK. |
|
| Chart Type Click the chart. Choose Chart | Chart Type on the
toolbar (or click the right mouse button).
Have a look at the types of chart a pick one. If
you don't like it, choose another type and finally click OK. |
|
| Printing a chart If the chart is an embedded chart on a worksheet, resize the
chart by clicking it and then dragging its selection handles. Chose View | Page Break
Preview and move the page break line so that everything fits on one page. You can also
choose File | Page Setup and change the orientation to Landscape.
If the chart is on a separate chart sheet, you can
scale it when you print it. Activate the chart sheet, click Page Setup on the File menu,
and then click the Chart tab. Under Printed chart size, click the scaling option you want.
If you click Custom, the chart will be printed at the size you make it when you drag its
selection handles.
You cannot print multiple chart sheets on a single
page. To print two or more charts on a page, create embedded worksheet charts, and then
resize them to fit on a single page. You can use the Page Break Preview command on the
View menu to more closely see the location of the charts in the print area. |
|
|
