Question Locked

Creating Charts displaying ranges in Excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can someone please guide me how I can create a chart in Excel the same as this: http://img209.imageshack.us/img209/5908/oecdlz9.png

2 replies

by gvdamn

When you want to create the complete chart you referred to, you need 5 data series in total. Only creating the "Range 2002-2006" part of the chart requires 2 data series. The 1st series represents the minimum; the 2nd the maximum. Make a chart and use the "Area" chart type, "Stacked Area" sub type. Turn the "Border" and "Area" off for the bottom data series (through "Format Data Series").

This discussion is closed to new replies.