I am trying to create a stacked cluster chart but failing miserably. Can anyone help, please? I have attached a sample.
I am trying to create a stacked cluster chart but failing miserably. Can anyone help, please? I have attached a sample.
It's not clear to me exactly what you are trying to do. In some ways, it looks kind of like a "Gantt" type timeline chart where you want a "floating bar" between the start and end dates (column C and E) that is divided into "completed" and "not completed". Your existing chart says that it is getting data from the N7 table, but it is really using array constants, so it took me a while to identify the values in N7 that it was using.
After looking at it for a bit, I felt like it would be easier to get what I think you want using the table in A:F, with some additions. Here's what I did -- see if this is close to what you want:
1) A lot of charting questions are really about the spreadsheet. I know that I will need "days completed" and "days remaining" columns in the spreadsheet for each phase, so I add those columns to the table. H8 =F8*(E8-C8) and I8=(1-F8)*(E8-C8). Copy down to the bottom of the table.
2) Select A8:A12, C8:C12, H8:I12 -> Insert -> Stacked Bar chart
2a) For some reason, Excel did not like that arrangement to the source data, so it removed C from the data series and used A and B together as the category series. I went into the Select Data dialog to fix it. I don't know how your version of Excel will handle that multi area range as source data, but be prepared to fix whatever it decides to do.
At that point, I had a chart that looks close to what I think you want (a Gantt like chart with dual colored bars showing completed/remaining for each category). Is that close? What did I get right, and what is missing?
Originally Posted by shg
You have the right concept of what I am trying to achieve. I will work my way through your response.
Thanks for your input.
Hi Mr Shorty
I followed your advice and now have what I set out to do.
Thanks for your help - appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks