Would be possible to create a pivot chart based on the table below with the following characteristics:
1- chart would have 2 stacked bars ( one for Jan, one for Feb ).
2- one color for each fruit based on the SOLD value.
3- only one extra line with value of 300, which based on the sum of Total for each month.
I'm looking for a way to do it without having an extra column with the sum of Total ( 300 ).
Thank you !
1- chart would have 2 stacked bars ( one for Jan, one for Feb ).
2- one color for each fruit based on the SOLD value.
3- only one extra line with value of 300, which based on the sum of Total for each month.
I'm looking for a way to do it without having an extra column with the sum of Total ( 300 ).
Thank you !