Chart help...
Apologies if this a dumb question (first time posting on these boards)... I have a compound column chart and I want to add another series, except I want the other series to sit next to the compound column, i.e. 1 1 3 1 3 1 3 2 3 2 3 2 3 ------ I can get the 3rd series to appear as a line chart with no problems, but whenever I try to turn it into a bar chart it moves into the compound column!! (ps I am trying to show Budget P&L next Actual P&L, where the Actuals is broken down into types) Is this possible or do I have to live with no extra column? -- Hornet_MT ------------------------------------------------------------------------ Hornet_MT's Profile: http://www.excelforum.com/member.php...o&userid=32473 View this thread: http://www.excelforum.com/showthread...hreadid=522580 |
Chart help...
4 7 6 6 1 12 3 8 2 2 4 3 5 5 4 Enter your data as above, select all of it and create stacked bar chart. The 7, 6 and 12 appear as single bars next to the stacks. -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=522580 |
Chart help...
sorry the paste didnt work - enter data as 4 7 5 6 8 9 3 4 6 2 3 4 1 2 2 select all data and make stacked bar chart, the 7, 6 and 9 will appear as single bars next to the stacks -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=522580 |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com