Column Chart with Dynamix Target Zones

[Tfrup12]

Hi,

I have multiple column charts (approximately 55) with a Y-axis of 0% to
100%. I have been asked to add "targets" or "zones" that display whether or
not a customer has reached a certain level, currently 52% to 57%, 57% to 69%,
and 69% to 100%, but the zones shift week to week. I have been toying with
adding a second axis but can not seem to figure out how to map the Major
units back to the Excel sheet? Any suggestions on how to approach this
problem would be greatly appreciated!

TIA,

B.

 

[Shane Devenshire]

Hi,

Here is the basic idea suppose the following is set up in A1:E10:

X-axis Values Target1 Target2 25%
x 10% 25% 50% 50%
y 35% 25% 50%
z 81% 25% 50%

In cells E1:E2 you enter a target values for that week. In C2 enter =E$1
and in D2 enter =E$2. Copy these formulas down as far as necessary. Chart
the range A110. Then select the Target1 series on the chart and choose
Chart, Chart Type and change it to a Line. Repeat for Target2 series.