Add a second bar in bar chart ?

Richard Coffre
Richard Coffre used Ask the Experts™
on
Hi all,

In the screenshot below, I created a bar chart using the data of columns "done" and "in progress".
To compare with the estimate, for each epic, I want to add a bar using the column "initial estimate".

How could I do this with Excel 2011 on Mac?

Best regards,
Richard

The current bar chart and the data
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010
Commented:
Hello,

I think what you are after is a clustered stacked column (or, in this case: bar) chart.  This can be achieved with a staggered data layout and some clever formatting of a stacked horizontal chart.

Jon Peltier has an excellent step by step tutorial on his web site:

http://peltiertech.com/clustered-stacked-column-bar-charts/

Have a go at that and if you get stuck, pipe up.

cheers, teylyn

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial