Plot a stacked column chart with multiple sets of data

[sbolt6]

Hello Everyone,

I have searched for a solution to this but I am struggling trying to find a way to plot comparative data on one chart that shows revenues by major customer over several years. More specifically, I am trying to plot each year on a stacked column that shows each of the major customers on top of each other and some of the "top 10" customers change from year to year. I have attached an example to try to show what I am looking for and I hope this is clear to everyone. I appreciate any help you might be able to provide. Thank you!

Scott

 

[GraH - Guido]

Guessing you are after this kind of chart?
I don't like it very much as it is cluttered, colourful and conveys no message at all.


Not sure if "all other customers" has to be on it. I delete your example too quickly.

 

[vletm]

sbolt6
... or this way without formulas

 

[GraH - Guido]

Might tell more like this (still cluttered though)


Or simplified


Should be "are" dropping I guess.

 

[sbolt6]

Thank you both! I agree with Guido that it does not convey a great message and is very cluttered. However, I was asked by our President to chart the data presented to him and could not make it work. Once again, I very much appreciate your expertise!

 

[sbolt6]

Might tell more like this (still cluttered though)
View attachment 74783

Or simplified
View attachment 74784

Should be "are" dropping I guess.

Thanks again Guido! I actually like the last one the most. Much appreciated!

 

[GraH - Guido]

Most welcome. And thank you for the feedback. Good you agree the last one is the best one.
Consider hitting some likes