Best chart for dual measures...

[Suraj]

Been a long time... how are folks here? :)

I'm working on a report that has dual measures that are related to each other.
For example, there are customer groups with members in (): young(50), middle(77), old(26).
They have contributed to this cause by giving $$: young($1m), middle($5m), old($11m).

I played around with stacked bar, pyramid and few other bubble charts but that doesn't really relay the concept.
The concept to show is to show both numbers and their $ contribution (or %) in same chart so we know at a glance, young group, even though they have a lot of members, contribute the least while old with very less members contribute the highest.

What's good way to represent this?
thanks

[AnalyticsWithJay]

Hi Suraj,

Have you played around with bullet charts? I can see some cool ways of representing this data using them.

Jay

[Suraj]

Yes, tried bullet chart and still playing with it.

[Michael75]

Suraj,

I also like the look of bullet charts, but haven't yet had the occasion to use one.

If visualizations are an option for you, have you thought of the Tornado viz?

https://www.ibm.com/web/wcm/connect/analytics/565b4b14-4039-4808-b6bb-d929a6d867ff/tornado_visualization.pdf?MOD=AJPERES&CONVERT_TO=url

I've used it to display two measures against a common category, and was very happy with the results  :)

Rgds, Michael

[Lynn]

Hi Suraj,
Sounds like you've got some good suggestions so far. I'll toss out another possibility.

You could try a combination bar and line chart. Imagine three bars representing young, middle and old along the X axis with the height as the member count along the primary Y axis. Then plot the $$ using a line on the secondary Y axis. Or swap the measures to have $ on the primary Y axis and thus controlling the height of the bar and put member count on the secondary Y axis for the line.

There are visualizations as well as traditional charts to support this.

[Suraj]

Thanks for comments.
It's little complicated than just dual measures.
Not only there are distinct dual measures, there are other groups that are created by the amount range as well.
I'm playing with combination and tornado charts.
Looks like I have to use at least two charts to properly show all the related data in a meaningful manner.