Two Axes on Stacked Bar Chart

Attached is a project resource planning sheet. I did a fake Gantt chart using stacked bar charts. I'd like to add the resources to a secondary vertical column and am having trouble. I tried using a COMBO chart. I got the second vertical axis, but it returned numbers instead of names. Is this possible to do?

THANKS ALL!

I like that as a work around. Thanks!

I don't see how that would work. The resource names are still coming up as 0-1.

Originally Posted by MrShorty

Assuming I understand what you want to do -- I want a secondary vertical category axis -- similar to the existing vertical category axis used by the stacked bar chart -- that shows the names from column E as the axis labels. Here's what I did:

1) Select the "line" series with the desired axis labels and text values -> Change Chart type -> Change back to stacked bar.
2) Select the same series again (it is kind of hard to select because of the 0 values, so I ended up using the dropdown list on the Format tab in my version of Excel) -> Format axis -> make sure it is still on the secondary axis system.
3) Find the command to add the secondary vertical (actually vertical) category axis and make the secondary category axis appear. The secondary vertical axis with the names appears.
4) Select the secondary vertical axis and format as desired ("categories in reverse order", for example).

Will something like that work for you?

I don't see how that works. I still have the probelm of the data being 0-1 instead of the resource names

Originally Posted by jeffreybrown

Not sure which post you are referring too, but we are happy to help and thanks for the feedback!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

My thread is screwing up....weird.