Share via

Help creating a Chart with a colour coded background

Anonymous
2015-08-19T02:15:06+00:00

I'm trying to create a chart that looks like this.  The areas of performance are shaded in the background whilst the actual result is charted over time.  I cant find anything like it.  Someone must have done it before. Perhaps I'm struggling with the name for it which is why I cannot find one.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2015-08-19T03:30:11+00:00

    Hello,

    some people call it a banded background. You can do this in Excel by combining an area chart with a line chart. 

    You need a data set for the stacked area chart to create the bands, and another set of data for the line (or column) chart in the foreground. 

    Jon Peltier has a very good step by step tutorial on his site here: http://peltiertech.com/excel-charts-with-horizontal-bands/

    If you get stuck, just pipe up.

    4 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-08-19T04:49:04+00:00

    Perfect. Thanks for the quick response Teylyn.

    0 comments