Two Kinds of Charts in Numbers

Question

Level 2

158 points

Two Kinds of Charts in Numbers

I would like to create 2 charts in Numbers on my Mac. The first chart is just the average miles for each month in a column chart. You can see in my chart that the average number is in a header row as is the label for that month. I just want to be able to see the average per/month in one chart. For all 12 months. Months are the x-axis. Then, in a second chart I would like to see the data in a stacked column chart showing how each year's month has contributed to that total.

Thanks in advance.

iMac, macOS Sierra (10.12)

Posted on Nov 1, 2017 11:24 AM

Reply

Answer 1

Nov 1, 2017 12:35 PM in response to MD_Gene

I would add a second table for the statistics (the average)... like this:

Add the new table and name the table "Stats"

make the first row and the first column headers.

B2=ROUND(AVERAGE(Monthly Miles::B), 0)

fill this across by selecting cell B2, copy

select cell B2 thru cell M2, paste

To plot the average, select cells B2 thru cell M2 in table "Stats",

then select the bart chart from the chart tools:

to plot the monthly mileage, select column B thru M of the table "Monthly Mileage":

now resize the charts as needed:

Reply

Answer 2

Barry

Level 9

59,957 points

Nov 2, 2017 5:30 AM in response to MD_Gene

Hi Gene,

You wrote: "You can see in my chart that the average number is in a header row as is the label for that month"

And therein lies the problem.

Data in header rows can be used in charts only as data. Move the monthly average figures into the body of the table, and you should be able to easily select that row and chart the data, using the instructions in Wayne's post.

Regards,

Barry

Reply