100% stacked bar chart with exploding segment for 2018 nicotine product sales and three year CAGR.

Nicotine Product Sales Worldwide

While cigarettes account for 87% of the $817B nicotine product sales, they are growing worldwide at just .5% per year. The $12B heated tobacco and the $16B vaping categories are growing much more rapidly. Nicotine product sales worldwide are displayed in these two 100% stacked bars with data columns added for three year growth rate (CAGR). Data are from the Global Trends in Nicotine – 2019 Update.

Nicotine Product Sales in a 100% Stacked Bar Chart with Exploding Segment and CAGR Columns

100% stacked bar chart with exploding segment for 2018 nicotine product sales and three year CAGR.

How I Made this 100% Stacked Bar Chart with Exploding Segment and CAGR Columns

The nicotine product sales data for this chart is presented below:

Data for 100% stacked bar chart with exploding segment for 2018 nicotine product sales and three year CAGR.

Here's how I made this  100% stacked bar chart with exploding segment and CAGR columns:

  • create a 100% stacked bar chart in PowerPoint
  • type in data from nicotine sales report into two bars in Mekko Graphics Data Editor with top 3 entries in first bar and next 4 in second bar
  • enter CAGR data into 3 Year CAGR column and add second column with header and no data
  • compute the sum in total row for both bars
  • computer "Other" by adding smaller segments that make up second bar
  • right-click in data editor to set last two columns as data columns formatted as percentage
  • open Format Chart, Values tab to designate "total" row as row to be used for calculated percentage
  • show values and percentages in segment labels
  • use number format to show segment values and bar totals as $B
  • hide axes and adjust internal chart margins
  • add segment links to indicate that "Other" segment is exploded into second bar
  • move data column title and CAGR data into area between bars
  • place second column title and rest of CAGR data next to exploded bar
  • align data column numbers with their respective segments
  • adjust colors to indicate first bar is all shades of blue, except other, and second bar and other are shades of green

Take This Chart and Make It Your Own

Download this chart and edit it using Mekko Graphics. See more bar charts in our chart gallery. Here are some other charts that may be of interest: