My goal is to create something similar to a bullet chart. I have two data points with different values - 2011 & 2012.
These points are on a bar chart with overlain series. I'd like to make 2012 thin and dark and 2011 light grey and wide so as to compare the two periods. As it stands, because both bars are exactly the same width, I cannot see both bars when they are 100% overlain.
Excel 2010.
When I change the width of the series, both bars adjust. How can I adjust a single bar? This is true when I select the one data point only - both bars still adjust.
These points are on a bar chart with overlain series. I'd like to make 2012 thin and dark and 2011 light grey and wide so as to compare the two periods. As it stands, because both bars are exactly the same width, I cannot see both bars when they are 100% overlain.
Excel 2010.
When I change the width of the series, both bars adjust. How can I adjust a single bar? This is true when I select the one data point only - both bars still adjust.
