Help Creating 2D Stacked Area Chart

Question

Level 1

11 points

Help Creating 2D Stacked Area Chart

I'm trying to make a 2D Stacked Area Chart of a company's Income Statement to show how certain components (e.g. A4-16) change over time, as a percentage of Net Sales (A3). I know I could include a line item for a % and then build the chart off of those values, but I'd rather not add additional rows to the spreadsheet. Is there a way to set it so that these values display in the stacked area chart, with the "Net Sales" representing the "whole"?

iWork-OTHER, OS X Mavericks (10.9.5)

Posted on Nov 9, 2015 8:49 AM

Reply

Answer 1

Nov 9, 2015 9:42 AM in response to user342

Make the first row and the first column headers

then select rows 2, 9, 10, 14, 16, then add the stacked bar chart

Reply

Answer 2

SGIII

Level 8

37,654 points

Nov 9, 2015 10:03 AM in response to user342

Bearing in mind that your selected expense lines may not add up to Sales so you may not be getting a true % of Sales measure, you can do something like this.

Choosing Percentage gives you something like this:

You have the same kind of Percentage option if you switch to a 2D Stacked Column.

SG

Reply

Answer 3

user342 Author

Level 1

11 points

Nov 9, 2015 10:04 AM in response to Wayne Contello

Thanks for the quick reply, though I'm not sure that does the trick. The solid blue in your chart seems to be "Net Sales", and then the other values are stacked on top of it. But I'm trying to visualize the percentage of these other values and how they relate to Net Sales over time.

Reply

Answer 4

Nov 9, 2015 12:22 PM in response to user342

I think you have the method as demonstrated in earlier posts. I was not clear what you actually wanted. Select the rows you want to plot, then add the chart

Reply

Answer 5

SGIII

Level 8

37,654 points

Nov 9, 2015 12:52 PM in response to user342

Or insert the chart, click Add Chart Data and select the rows you want, in this case not including the Net Sales row.

You can select non-contiguous rows (for example Cost of Sales and then the various Expense lines) by holding down the command key as you make your selections. I found it easier to click in the right-most column and drag left until the whole row(s) is(are) selected.

SG

Reply

Answer 6

Rebells

Level 1

4 points

May 20, 2017 3:40 AM in response to SGIII

Thanks!

This was super helpful for my thesis!

Thanks!!!

Reply