• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

multi group stacked column chart

ragup

New Member
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.
 
Hi ,


It would be nice if you could upload a worksheet containing the row and column labels ; this would save others some effort.


Narayan
 
Back
Top