Can you gurus help me create a stacked column chart in excel?
I have 15 rows of salespersons with 8 columns of sales for 2 products arranged as :
Salesperon, CurrA, CurrB, MtdA, MtdB,QtdA,QtdB, YtdA,YtdB.
I need to create a stacked column chart for each salesperson.
There should be 4 stacked columns each with sales of product a and product b.
First chart column will be Curr for A and B
Second chart column will be Mtd for A and B
Third chart column will be Qtd for A and B
Fourth chart column will be Ytd for A and B.
This may a dynamic chart with a drop down for each sales person.
Many thanks in advance.
I have 15 rows of salespersons with 8 columns of sales for 2 products arranged as :
Salesperon, CurrA, CurrB, MtdA, MtdB,QtdA,QtdB, YtdA,YtdB.
I need to create a stacked column chart for each salesperson.
There should be 4 stacked columns each with sales of product a and product b.
First chart column will be Curr for A and B
Second chart column will be Mtd for A and B
Third chart column will be Qtd for A and B
Fourth chart column will be Ytd for A and B.
This may a dynamic chart with a drop down for each sales person.
Many thanks in advance.