View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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