Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I add a goal line to a stacked bar chart in excel?
I have a stacked bar chart of categories that total 100% sorted in 'ease of
resolution' order. I want to include a "goal" line that would show a varying goal throughout the year. (85% - Jan, 86% Feb, etc.) The result would identify how close to goal could be achieved by resolving the issues in order. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I add a goal line to a stacked bar chart in excel?
You say a goal bar but then it sounds like you want a collection of goal bars?
For one goal bar - add another series to your chart with the value of the goal at all points: .85,.85,.85,.85 .... After plotting it select the new series on the chart and choose Chart, Chart Type and pick Line. -- Thanks, Shane Devenshire "rheinzy" wrote: I have a stacked bar chart of categories that total 100% sorted in 'ease of resolution' order. I want to include a "goal" line that would show a varying goal throughout the year. (85% - Jan, 86% Feb, etc.) The result would identify how close to goal could be achieved by resolving the issues in order. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I add a goal line to a stacked bar chart in excel?
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "rheinzy" wrote in message ... I have a stacked bar chart of categories that total 100% sorted in 'ease of resolution' order. I want to include a "goal" line that would show a varying goal throughout the year. (85% - Jan, 86% Feb, etc.) The result would identify how close to goal could be achieved by resolving the issues in order. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cluster & stacked & line in one chart | Charts and Charting in Excel | |||
How do I get a value of a calculated point on an excel line chart? | Charts and Charting in Excel | |||
How do I add an indicator line to a Gantt chart in excel? | Charts and Charting in Excel | |||
How do I add base line to a stacked bar chart? | Charts and Charting in Excel | |||
How to create combination stacked area and line chart? | Charts and Charting in Excel |