Bar within a bar

B

Balaji Viswanath

Hi everyone,

Want to draw a bar chart where 2nd row values should be drawn within the 1st
row values.

Given below the data:
Dec'07: 24.5 (1st row) 17.45 (2nd row)
Feb'08: 30.5 (1st row) 15.3 (2nd row)
Jun'08: 24.25 (1st row) 14.27 (2nd row)

By default, 24.5 is getting sumed up with 17.45 or otherwise I am getting as
two separte bar. Instead I require 24.5 and within it I want 17.45.

Could you please tell whether it's possible and if yes, how to achive it.

Thanks in advance.
 
J

Jon Peltier

It's probably clearer to the reader if you use a clustered column chart and
leave the two columns side by side. You could experiment with the overlap:
100% overlap puts the second bar directly in front of the first.

If you want the second column to be within the first, such that the first is
taller and wider, move the second series to the secondary axis, and adjust
the gap widths of both series (Format Series > Options tab > Gap Width) so
the second series has a greater gap width.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combination Stacked Bar with Single Bar Chart 2
Combine 2 Charts 2007 Excel 1
Stacking data from within a series within a bar chart 1
Replace cell formula with revised text as noted within a cell valu 3
When building a chart Dates are been included that are not in thedate range 1
Search yields no results to calculate number of days based on Rang 5
Crosstab Query based on Ordinal Values 6
SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year) 2

Top