Charts

<< Click to Display Table of Contents >>

Charts

In spreadsheets containing nothing but long columns of numbers, it is often hard to interpret their meaning. PlanMaker offers easy ways to turn raw numbers into charts that get the point across.

chart_sample

In this chapter, you will learn everything you need to know about charts. The following topics are covered:

Inserting charts

First, you will learn how to create a chart: Select the cells containing the data to be displayed, choose the ribbon command Insert | Chart frame and select a chart type.

Editing charts

This section contains all the information you need to edit charts. You will learn how to change the chart type and the arrangement of the data series, how to work with the individual chart elements (data series, axes, legend etc.) and how to change the general chart properties.

Updating charts

By default, charts are automatically updated when you change the content of any of the cells they are based on. So if values in these cells change, the chart is updated immediately. If desired, you can disable automatic updating.

Moving charts to another worksheet

The ribbon command Chart | Chart location allows you to move a chart to another worksheet or even create a separate chart worksheet for it. A chart worksheet contains no table cells but solely the chart in its full size.

Saving charts as pictures

The ribbon command Chart | Save chart as a picture allows you to save an image of a chart in a picture file.