Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 A1:D10. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Target line to a column chart? | Charts and Charting in Excel | |||
How do I add a target line to a chart? | Charts and Charting in Excel | |||
target line in bar chart | Charts and Charting in Excel | |||
Chart Target Line | Charts and Charting in Excel | |||
Add target to trend chart | Excel Discussion (Misc queries) |