software

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: www.excelforum.com/member.php...oamp;userid=31755
View this thread: www.excelforum.com/showthread...hreadid=514798Hi,

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info