If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Positioning Numeric Values Resulting from 6 Column Array Formula | Sam via OfficeKB.com | Worksheet Functions | 2 | January 5th, 2006 02:03 AM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
problem with column charts and two Y axes in Excel 2003 | napofrog | Charts and Charting | 1 | October 21st, 2005 03:04 AM |
Using Validation to force entry into cells? | Mark | General Discussion | 16 | October 27th, 2004 09:23 PM |
paste excel 2003 chart into powerpoint | Nick F | Powerpoint | 1 | September 14th, 2004 05:12 AM |