Excel 2016: Stacked Bar Chart in Gantt-like Format 1

[CrystalFacets]

I need to create a chart that shows the active-not active status of several products within a given time period and found a solution online.

However, I want to add a secondary vertical axis that would contain each product name and have not been able to successfully accomplish this.

As a reference, the Excel file with the chart in question is attached. Please note that the vertical axis on this chart is formatted as Axis Type = Date Axis in order to allow multiple start-stop activities for any given product to be displayed.

Any assistance would be appreciated.

 

[SkipVought]

Hi,

Why a secondary axis?

Of what significance are the numbers in column C?

Why not change the range reference for the Category Axis to the range for your product names in column B? I'd probably select Categories in Reverse Order.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[CrystalFacets]

Before providing feedback to your questions ... This is my first time using TT since the website changed. Good to hear from you, Skip. Now, on to you questions. ...


Why a secondary axis?
See answer under your 2nd question.


Of what significance are the numbers in column C?
Thanks for sending back your solution. FYI ... When the left axis was changed to the Product column, there are now multiple 'lines' on the chart for Product A, D and E. My goal is to have one line only on the chart for each Product even if the Product has multiple active/inactive entries on the table.

However, it would be meaningful to have the Product name on the chart and thought a secondary axis would accomplish this while allowing the one line per Product view to remain intact. For some reason, I've not been able to add the 2nd vertical axis to the chart.


Why not change the range reference for the Category Axis to the range for your product names in column B? I'd probably select Categories in Reverse Order.
See my feedback under question #2 above.

 

[SkipVought]

In order for a secondary axis to be added, it needs data, that is values for the 8 categories and value data that will not skew the chart. I can't figure that one out yet.

However, I have in the past, super-imposed one chart over another. I remember doing a pie/donut chart, where I super-imposed 5 or 6 charts.

I posted a crude example for you as a start. I'd use VBA to automatically align as changes are made.

BTW, I don't quite understand (and I supposed I really don't need to) why active/inactive, some bars don't display??? What's the point? You actually have superimposed stacked bars; in other words, stacked bars on top of stacked bars.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[CrystalFacets]

Skip,
Thank You for a pretty creative solution! It will work this time.

 

[SkipVought]

Thank you.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]