Bar Chart Open/Closed Tickets (%) vs Line Depicting Inventory Total for Multiple Year

Can you create a bar chart showing "Open" and "Closed" orders using percentages vs inventory with a line chart for multiple years?

Thank you in advance for all assistance.

tm

Thank you for replying! You pointed me in the right direction. I am not sure why the charts had array constants (wasn’t my chart but I should have noticed this). I revised and finally got the result wanting.

Thank you for taking the time to help me. Very appreciated.

Originally Posted by MrShorty

It's not quite clear to me exactly what you want, but I am optimistic that what you want is possible.

I notice that all of your charts are using array constants for data series instead of using ranges in the spreadsheet. Is there a reason for this? I'm not sure that it matters, whether you use cells in the spreadsheet, or array constants in the chart, the solution seems as simple as putting the right data into the data series. If you want one of the column series to be L8:O8, then assign that range to the chart series (or enter those values into the array constant, if that's how you prefer to define the data series). You may want to use a secondary Y axis to separate the volume data from the percentage data (https://support.office.com/en-us/art...rs=en-US&ad=US for some reason MSFT decided to bury the instructions for adding a secondary axis into something talking about creating combo charts. In this case, since your chart is a column+line combo chart, that should not make it difficult to follow the instructions).

As near as I can tell, the answer to your question is to use the correct values/ranges in defining the chart data series. I tend to use the "Select Source Data" dialog to do this. Is there more to your question than that?