Add a second bar in bar chart ?
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
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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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/clu
Have a go at that and if you get stuck, pipe up.
cheers, teylyn
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/clu
Have a go at that and if you get stuck, pipe up.
cheers, teylyn
Premium Content
You need an Expert Office subscription to comment.Start Free Trial