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.


--
bolton707
------------------------------------------------------------------------
bolton707's Profile: http://www.excelforum.com/member.php...o&userid=31755
View this thread: http://www.excelforum.com/showthread...hreadid=514798

Column chart excel 2003
 

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