View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Tfrup12 Tfrup12 is offline
external usenet poster
 
Posts: 8
Default Column Chart with Dynamix Target Zones

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.