• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with stacked bar chart

Loranga

New Member
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
 
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
 
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
 
Back
Top