How do I add a goal line to a stacked bar chart in excel?

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a stacked column/line chart combination? 3
how do I add a goal line for a bar chart? 1
How can I add a new axis as a line chart toa stacked bar chart 1
Add line series to stacked bar chart 1
How do I add a horizonal target/goal line to a line chart? 2
How can I combine a stacked column chart and line chart? 1
2 axis chart stacked bar next to bar with line 1
How to create a stacked bar, line combination chart 2

Top