$5.00

P&L as a column chart

$5.00

This an unusual visualisation of a profit & loss statement. Instead of the standard table, I show the values in a stacked column chart. You can see how variable costs (COGS) grow in proportion to sales, while the other operating expenses stay almost constant. If you have only a few lines of financial data to show, this can be a good alternative to a table.

The years with a profit are fairly straightforward, you can open the underlying Excel sheet in the chart and change the values to your own need. The years with a loss are a bit trickier. I calculated the required values and added datalabels manually. 

The data labels for the gross profit are also added by hand.

Here is the data table I used to create this chart.

This layout is available as either a PowerPoint or Keynote template

Here is the short version of the user license that go with our templates:

  • You are free to do whatever you want with the template, and use it in any document you see fit
  • 5 users can use a template you download, if you work with bigger teams, please contact us
  • You cannot sell any of the material you download on this site unmodified, i.e., run a competing template business
  • Consultants and service providers: please purchase a new license for each new client that makes use of the slides. Best is to have your client buy the slide license, they can then continue to use it after the project is finished.

A subscription to the SlideMagic template store gives you access to unlimited downloads of PowerPoint or Keynote slides:

  • Experiment freely with different slides without worrying about cost, a different type of Venn diagram, 5 bullet points instead of 4? Need a wide screen version instead of a print? Just download another slide
  • Use SlideMagic as your online slide library with a powerful search engine, rather than looking through downloaded files on your hard drive
  • New slides are added to the store all the time, making a subscription better value by the day
  • Lock in the attractive "beta" subscription rate of $99 per year

Visit the subscription sign up page for more information. After subscribing, all prices in the store for your account should fall to $0.

Regular price $5.00

This an unusual visualisation of a profit & loss statement. Instead of the standard table, I show the values in a stacked column chart. You can see how variable costs (COGS) grow in proportion to sales, while the other operating expenses stay almost constant. If you have only a few lines of financial data to show, this can be a good alternative to a table.

The years with a profit are fairly straightforward, you can open the underlying Excel sheet in the chart and change the values to your own need. The years with a loss are a bit trickier. I calculated the required values and added datalabels manually. 

The data labels for the gross profit are also added by hand.

Here is the data table I used to create this chart.

This layout is available as either a PowerPoint or Keynote template

Here is the short version of the user license that go with our templates:

  • You are free to do whatever you want with the template, and use it in any document you see fit
  • 5 users can use a template you download, if you work with bigger teams, please contact us
  • You cannot sell any of the material you download on this site unmodified, i.e., run a competing template business
  • Consultants and service providers: please purchase a new license for each new client that makes use of the slides. Best is to have your client buy the slide license, they can then continue to use it after the project is finished.

A subscription to the SlideMagic template store gives you access to unlimited downloads of PowerPoint or Keynote slides:

  • Experiment freely with different slides without worrying about cost, a different type of Venn diagram, 5 bullet points instead of 4? Need a wide screen version instead of a print? Just download another slide
  • Use SlideMagic as your online slide library with a powerful search engine, rather than looking through downloaded files on your hard drive
  • New slides are added to the store all the time, making a subscription better value by the day
  • Lock in the attractive "beta" subscription rate of $99 per year

Visit the subscription sign up page for more information. After subscribing, all prices in the store for your account should fall to $0.