Costas
Member
Hi Chandoo,
I have an excel table with sales invoices and I'm trying to create a chart that shows the monthly sales per industry group as sales $ amounts, as number of invoices and as average sales $ per invoice. I created a pivot chart to do this but I can't get the sales $ on the left Y axis and the other two on the right Y axis with different scales on each Y axis. Please see sample file attached.
Thanks
Costas
I have an excel table with sales invoices and I'm trying to create a chart that shows the monthly sales per industry group as sales $ amounts, as number of invoices and as average sales $ per invoice. I created a pivot chart to do this but I can't get the sales $ on the left Y axis and the other two on the right Y axis with different scales on each Y axis. Please see sample file attached.
Thanks
Costas