Adding Shaded Area in Pivot Chart

[therichterscale]

Hello,

I am trying to accomplish in adding a shaded area on my pivot chart. The desire is to put a shaded area between 400,000 and 800,000. Essentially, 400,000 is my min value and 800 is the max. My administration wants to see on the graph when these values go below or exceed. I played with adding horizontal lines however that adds more data to my pivot table. Is there a simple method to add in a shaded area to the stacks?

 

[therichterscale]

Hello,

I am trying to accomplish in adding a shaded area on my pivot chart. The desire is to put a shaded area between 400,000 and 800,000. Essentially, 400,000 is my min value and 800 is the max. My administration wants to see on the graph when these values go below or exceed. I played with adding horizontal lines however that adds more data to my pivot table. Is there a simple method to add in a shaded area to the stacks?

View attachment 99408

 

[therichterscale]

Just providing some clarity, attached is what I want to accomplish. Keep in mind I have slicers, so I would like the shaded area to flow with the slicers.

 

[Jon Peltier]

The usual tricks to add a shaded band to a chart require adding one or more data series, and their formatting provides the shading.

However, you can't add non pivot table data to a pivot chart.

You can make a regular chart from a pivot table, assuming the slicer settings don't change the dimensions of the pivot table.