L Loranga New Member Jan 15, 2010 #1 Hi, Is there any way this chart can be done and have all the data on the same row instead of two rows? http://cid-9dbe9148723870b9.skydrive.live.com/self.aspx/.Public/chart.jpg
Hi, Is there any way this chart can be done and have all the data on the same row instead of two rows? http://cid-9dbe9148723870b9.skydrive.live.com/self.aspx/.Public/chart.jpg
Hui Excel Ninja Staff member Jan 15, 2010 #2 Loranga It can be done but not as 1 chart Make 1 Chart with 1 bar, series A Make a second chart chart as a stacked Column Chart, Series B - D Now set the scales of both Y Axis to be the same 0 to 30,000,000 in your case With one of the charts make the Background and Chart Area color set to none Delete all the Titles, Legends + Y axis labels on that chart Only leave an X-Axis and Series name Now move the transparent chart infront of the other chart and move it side ways until it fits Adjust Column width to suit May be fiddly but can be done
Loranga It can be done but not as 1 chart Make 1 Chart with 1 bar, series A Make a second chart chart as a stacked Column Chart, Series B - D Now set the scales of both Y Axis to be the same 0 to 30,000,000 in your case With one of the charts make the Background and Chart Area color set to none Delete all the Titles, Legends + Y axis labels on that chart Only leave an X-Axis and Series name Now move the transparent chart infront of the other chart and move it side ways until it fits Adjust Column width to suit May be fiddly but can be done
T TessaES New Member Jan 15, 2010 #3 You could make one row with the data and then two hidden rows with the data as you have it now. Or manually edit the dataseries: for series a select the cell with the data, then hold control and select an empty cell for series b,c,d select the empty cell first, then the cell with the data
You could make one row with the data and then two hidden rows with the data as you have it now. Or manually edit the dataseries: for series a select the cell with the data, then hold control and select an empty cell for series b,c,d select the empty cell first, then the cell with the data