Column chart excel 2003

I have some 3 columns of data in Excel :-

1st column has category names
2nd column has figures associated with these
3rd column more figures

I wish them to go into a chart which has categories along the x-axis.
An axes up the left side and one up the right side.

The problem is I can't get 2 columns to appear side by side for each category. I can get them so they stack ontop of eachother but not side by side.

Hi,

The trick is to stagger your data.
See Jon Peltier's page of links for more information on cluster &
stacked column charts.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

bolton707 wrote:
> I have some 3 columns of data in Excel :-
>
> 1st column has category names
> 2nd column has figures associated with these
> 3rd column more figures
>
> I wish them to go into a chart which has categories along the x-axis.
> An axes up the left side and one up the right side.
>
> The problem is I can't get 2 columns to appear side by side for each
> category. I can get them so they stack ontop of eachother but not side
> by side.
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info