Graph Help

One way is to do something like this:

You set up a separate summary table that is used to generate the chart. The relevant months are listed in the first column, which is defined as a Header Column (important). The formula in B2, filled down is:

=SUMIF(Table 1::C,A2,Table 1::D)

To generate the chart, select its cells including the Header Column and Header Row and in the menu choose Insert > Chart > 2D Mixed. Click the Edit Data References rectangle and in the chart choose Delete Series in the dropdown that appears when you click the dot above the Number of Clients column. The selection should look something like this:

Then "pretty up" the chart to taste.

A quick way to learn a little about what can be done with charts is to open the 'Charting Basics' template at File > New in the menu.

SG