Automated Shading

[accelerator]

Football Field.xls

Hi Guys,

In the attached workbook, I have manually shaded a certain region on this chart, and was hoping someone would have an easier method to automate the shading. For example, if I just enter 200 and 300 it will shade between 200-300. Is there someway to do this? Maybe another bar chart running on a secondary axiss or something?

Thanks a bunch!

[Steve=True]

Hi Accelerator,

I had to redo your chart because an option you chose stopped the 2nd Series from being selectable.

You are correct in stating that you need a second stacked chart series on the 2nd axis with the transpency set to lighter value.

Here is the file:Football Field Banding.xls

Please let me know if this helps.

Thanks

Steve=True

[Steve=True]

Hi Again,

You inspired me to create a video on this topic.

http://youtu.be/hKjodKrzHIA

Let me know if this helps.

Steve=True