I am trying to combine a line shart with a shaded range. Anybody know how to do this? Been searching around but can't find answers. Essentially I am trying to replicate the attached file. I cant upload my own work so far because the file is too big. Thanks!
The band is created using 2 series plotted as area.
You can either use clustered area, which allows you to use values as is, and make the smaller area the same colour as the plot area to mask the bottom part.
Or use stacked area, you will need to adjust the maximum values, and set the bottom area to have no fill.
To get smooth borders to the band you will need many data points.
See attached
Thanks so much for your reply. I have used your chart and edited it to fit what I'm doing. I understand how you use the two different Chart Types to do that, but can you tell me how I can do that if I am building the chart from scratch say from Chart Wizard?
Thanks again.
Create the chart in the style with the most series, so in your example Line chart.
The select the series you want to change to area and use right click > Chart Type. Pick Area. Repeat for other series.
Okay got it. Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks