How to make a fan chart

Written by basim usmani
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to make a fan chart
A fan chart is used to measure possible outcomes based on past data. (Hemera Technologies/ Images)

A fan chart is used to measure possible outcomes based on past data. It looks like a general line chart, but the line fans out on either side representing a range of predictions, with the central line itself being the most likely outcome. They are used often in fiscal matters, like forecasting future inflation.

Skill level:

Things you need

  • data
  • graph paper
  • pen
  • ruler
  • calculator

Show MoreHide


    Plot the Data

  1. 1

    Determining what your X and Y variables represent, plot the data on the graph. If you are using X as a variable of time, you'll want to plot old data, and then whatever you have most recently.

  2. 2

    Determine the Highest Probability Density Interval by drawing a straight line on the vector where the most points rest. This line will be your most likely outcome. If the points are laid out symmetrically, the line will rest on the mean. If the points are non-symmetric, the central line of the fan should be where the mode is (as in the most repeated number in your column of Y-axis data).

  3. 3

    The most total points that can be connected with a single line the more probable the outcome will be. Connect the points above and below your central line, which will serve as your upper and lower range.

  4. 4

    Shade the points in the centre the darkest, getting fainter as you reach the upper and lower ranges. This graph should now be legible, with the darkest areas being the most probable outcome.

Tips and warnings

  • You can also use Microsoft excel to create a fan chart easily. Go to "Chart Types" and click on "Standard Types." Choose the graph selection called "XY(Scatter)"; just make sure to select the subtype of "Scatter" type of graph. You get a fan graph when you select the subtype as "Scatter. Compares pairs of Values." Voila!

Don't Miss


  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.