i am trying to make a stacked graph chart. i want to put male and female as one bar for each group. i have attached figure for explanation. Can someone please help.
Here is the data for which i want to create a stacked graph
total1 total2
Male Female Male Female
group 1 400 100 100 100
group 2 100 50 200 150
group 3 150 100 300 300
group 4 300 50 50 200
thanks in advance
Check enclosed file...
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
I looked at this earlier today and did not understand the request at all!!
Syguy: you want 4 bars (Group 1 - 4), with a figure for male and female in each. That makes 4x2 = 8 data points. However, you have given us 16 data points. Can you post the data IN AN EXCEL sheet (not a picture), if HerryMarkowitz's response is not what you need. Then we can really see how it is set up...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
You need to change your data layout.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks