Adding a horizontal line to a stacked bar chart

Hello All,

I have a requirement to create a Forecast Vs Quota chart.

The individual Sales Rep forecasts are displayed in a vertical stacked bar chart.

now I want to add a horizontal line which indicates the quota for the entire sales team.

I have the stacked bar done, but I can't figure out how to add the horizontal line into this chart.

Any help would be welcome and greatly appreciated.

cheers,

Mel Harding

 

Question Info


Last updated May 22, 2019 Views 2,066 Applies to:
Answer
Answer

Check if this is fine for you.

Of course, here I was not successful in getting a horizontal line for the target.

See if you can manage with this, until you get your desired solution.

1. The data is entered in cells A2:C9

2. Plot a stacked Column Chart using this range

3. Now select the column showing the Target

    a. Change it to scatter chart type ( a combo chart - with stacked column and scatter plot )

    b. while keeping the Target as selected, do the following

         ( 1 ) Change the marker as a Line with

                 -  the thickness as per your choice

                 -  fill color of your choice

Excel is Awesome!! One problem can have multiple solutions.
If my answer solves your problem, please tick mark it as Answered.
Cheers RajeshC

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.