Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combo chart format- what is the best way to achieve this design?
I have a line chart with multiple lines that represent performance Jan-Dec. I
want to put in something like a stacked column chart on the right edge of this line chart to show target ranges for end-of-year performance. In my case, the desired effect is to have the last possible point on the line graph (Dec) touch the edge of the stacked column chart to make it very clear where the line hit the target ranges. I played with 2-axis charts to make it easier to move the stacked column around, but then I run into problems with scale- if the first Y axis scale changes, then I have to manually change the stacked column scale to match, otherwise the lines don't hit the stacked column in the right place. I need a fully automated solution, so that won't work. I tried adding "month 13" and putting the stacked data there; it worked pretty well, the only problem is that the Dec data point ends in the "middle" of the Dec gap , and the closest I can get the stacked columns is at 0% gap width, so I'm still 50% gap between the last data point (Dec) and my target ranges (blank month 13). Are there any clever (and hopefully simple) ways to get the Dec point to touch the stacked column graph? My other option seems to be to put the stacked columns in Dec, but then it actually overlaps my data (also undesirable, because I need to put labels in the stacked column, and then the overlap with Dec data makes it hard to read). I appreciate any advice or suggestions! Keith |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combo chart format- what is the best way to achieve this design?
Anyone?
Thanks! Keith "ker_01" wrote: I have a line chart with multiple lines that represent performance Jan-Dec. I want to put in something like a stacked column chart on the right edge of this line chart to show target ranges for end-of-year performance. In my case, the desired effect is to have the last possible point on the line graph (Dec) touch the edge of the stacked column chart to make it very clear where the line hit the target ranges. I played with 2-axis charts to make it easier to move the stacked column around, but then I run into problems with scale- if the first Y axis scale changes, then I have to manually change the stacked column scale to match, otherwise the lines don't hit the stacked column in the right place. I need a fully automated solution, so that won't work. I tried adding "month 13" and putting the stacked data there; it worked pretty well, the only problem is that the Dec data point ends in the "middle" of the Dec gap , and the closest I can get the stacked columns is at 0% gap width, so I'm still 50% gap between the last data point (Dec) and my target ranges (blank month 13). Are there any clever (and hopefully simple) ways to get the Dec point to touch the stacked column graph? My other option seems to be to put the stacked columns in Dec, but then it actually overlaps my data (also undesirable, because I need to put labels in the stacked column, and then the overlap with Dec data makes it hard to read). I appreciate any advice or suggestions! Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help figuring out chart design | Charts and Charting in Excel | |||
How can I design a Control Chart with Excel? | Charts and Charting in Excel | |||
Can you design your own chart in excel | Charts and Charting in Excel | |||
Trying to achieve defined format with any Excel | New Users to Excel | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) |