Highlight background of chart

[morerockin]

Hello all,

Does anyone know how I can shade the background of my graph like below?

2015-04-09 10_27_47-Presentation1 - Microsoft PowerPoint.jpg

Here is my graph attached. It's a waterfall that one of the moderators helped me with

Book1.xlsm

[adhawan06]

Hi More,

I have attached a workbook for your reference. Please see if this is what you were looking for.

[morerockin]

That looks great.

How do I change the colors?

How do I add the multiple labels in each section like below?

2015-04-09 12_51_14-Presentation1 - Microsoft PowerPoint.jpg

[adhawan06]

Hi More,

Nice to see that this is what you were looking for..

You can simple add "Rectangle" shapes by going in Insert-->Shapes.

Adding Shapes.png

And moving to your next question...you can simple change the color by doing right click on "Plot Area" box and the below Plot Area will get populated may be right side on your window.

Format Plot Area.png


I hope this will help you to get what you looking for exactly.

[morerockin]

Thank you!! Last dumb question. Do you now How I change the color of the bar?

[adhawan06]

No Its not dumb question...This is the best platform to exchange knowledge with each other sitting at different places.

Click on any graph and from plot area option or using "fill color" option you can change the color of the bar.







Don't forget to say thanks by adding *Add Reputation If I helped you. Also, please take few seconds to marked this thread as SOLVED if your query has been answered.

[Andy Pope]

You might find you have better control if you use a few dummy data series to shade the plot area.

3 area chart series on secondary axis.

[adhawan06]

Hi More,

Thanks for adding the reputation and your feedback.

Please take few seconds from your valuable time to mark this thread as SOLVED if your query has been resolved.