Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked chart
Hi. I'm hoping this can be done in Excel and that the fabulous discussion
group can show me how... I need a "thermometer" type chart and think a Stacked chart might work. Basically, I need to set a goal and show how I'm meeting it. I'm trying to meet an ultimate goal of 57, so 60 could be the max. I've already completed 28. Each week I set a weekly goal, say for this week, a goal of 3 but only complete 2. I'd like the stacked chart to show 28 in one color, a line 3 above that and have only 2 of the 3 colored in. Next week, the goal may be 6 with 7 completed (including the lag from the previous week), so I'd like that in a different color stacked above, bringing my stack to 28 + 2 +7 . I'd like a Y axis with 5 unit increments. Can't tell you how badly my chart attempts have turned out. Can this be done? And how do I set up the data... |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked chart
Found the answer on Andy Popes' website. Thanks Andy!
"Stephanie" wrote: Hi. I'm hoping this can be done in Excel and that the fabulous discussion group can show me how... I need a "thermometer" type chart and think a Stacked chart might work. Basically, I need to set a goal and show how I'm meeting it. I'm trying to meet an ultimate goal of 57, so 60 could be the max. I've already completed 28. Each week I set a weekly goal, say for this week, a goal of 3 but only complete 2. I'd like the stacked chart to show 28 in one color, a line 3 above that and have only 2 of the 3 colored in. Next week, the goal may be 6 with 7 completed (including the lag from the previous week), so I'd like that in a different color stacked above, bringing my stack to 28 + 2 +7 . I'd like a Y axis with 5 unit increments. Can't tell you how badly my chart attempts have turned out. Can this be done? And how do I set up the data... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
?make a combo chart with 1 stacked bar and 1 not stacked, + show t | Charts and Charting in Excel | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel |