Hi,
Lay your data out in the range A1:E5
PosA PosB Pad NegB
Sample 1 2.5 10.3 0 -5.3
Sample 2 8.9 20.3 0 -2.5
Sample 3 3.8 14.9 0 -7.4
Sample 4 0 7.1 0 -7.1
Create as clustered column chart.
Double click NegB series and set Axis to secondary
Select Pad series and also set Axis to secondary
Delete secondary Y axis.
Double click X axis and set tick labels to low.
Cheers
Andy
> I have to create a chart that has three columns that I would like to show as
> two bars,the columns are one with a fixed amount and the other two with a
[quoted text clipped - 10 lines]
>
> Any help would be greatly appreciated! Thanks!!!!

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
DQuint - 07 Sep 2006 16:44 GMT
Brilliant! You are a lifesaver, thanks!
> Hi,
>
[quoted text clipped - 30 lines]
> >
> > Any help would be greatly appreciated! Thanks!!!!