Creating a Stacked Column Chart with 2 Ranges on same column
Hi, I have the following data: - Months over a year (e.g. Jan 2017, Feb 2017, Mar 2017, etc) - Categories of food (e.g. sugar, cookies, flour, etc) - Revenue from selling each category per month - No. of transactions per category per month I'd like to make a stacked column chart with two axis where the x-axis shows the months over a year and the two y-axis are no. of transactions and revenue from selling categories. The stacked columns should be split into the different categories. The issue I am having is that I need the revenue and no. of transactions to be shown on the same stacked column per month, just corresponding to the different y axis. Is it possible to do this on excel and how do I go about this?