Dynamic Line Graphs

[gomukuma]

Good Evening.
I am hitting a bit of wall trying to think of ideas on graphing some data so it is relevant for the user as part of a dashboard.

We have 4 measures I want to graph, I only want to show 1 graph on the dashboard at a time giving the user the option of which of the 4. (AV% / POE % / Contribution % / GM %)

I have found some great articles on this but I get stuck when it comes to having the option of which customer to graph.

I'm hoping someone could help, the data attached is also a pivot table but I don't seem to be able to create a pivot chart with the option to filter on the values so have just extracted the data.

Any advise on how to structure the data/options available on how to graph dynamically would be very much appreciated!

Rgds
GK

 

[chirayu]

With Pivot Chart. This what u want?

 

[gomukuma]

Thanks Chirayu.
I'm trying to get to something slightly different, but seemingly impossible:
I want a line for each family group and to be able to choose which metric is shown between the 4, using the filters.

 

[chirayu]

Do you want to sum Values or Average them. Show monthly trend or YTD

 

[p45cal]

See sheet Data (2) in the attached.
It required a re-arrangement of the data, but I suspect this arrangement might be closer to your original pivot table source data.

 

[chirayu]

Looks like you're adding the percentages together. Isn't that going to give values over 100%? not really an accurate representation. You'd be better of using raw data rather than calculated figures. But I've made it according to your specifications