If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Column Chart with Dynamix Target Zones
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Tfrup12" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|