How do I make a chart from two columns of data?

One way is to set up a separate table containing each date's count and amount. Then base the chart on that.

Starting with something like this:

Collapse Peer Groups:

Select the dates that are in the visible cells, and command-c to copy.

Click in a separate table and Edit > Paste and Match Style

Add a formula for the day's count (number of orders):

Add a formula for the day's amount of total orders :

Fill down the formulas down:

With the cells selected in the Chart Data table insert a 2D Scatter Chart:

Giving you something like this:

Because the counts are so small relative to the amounts, you can change to logarithmic scale on the Y axis to see the relationship more clearly.

And experiment with the Steps in Axis panel and Connection Lines in the Series Pane (after clicking a series in the chart) giving you something with the appearance you want.

SG

Hi robtour,

Take a look at Template Chooser > Charting Basics > 2-Axis Graph.

That shows an X axis and a Y1 axis and a Y2 axis

You can change the appearance of a series from Column to Line or Area.

Click on a Series.

Format Panel > Series > Show Series As

'For your data with 2 Y axes, it may look like this, using SG;'s suggestion of a Summary table with COUNTIF and SUMIF as the data for the graph.

Please call back with questions.

Regards,

Ian.