Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have two charts with two different alternate states and two sets of list boxes driving the selections for these charts.
When I make selections with STATE A chart the chart scale change dynamically which is great.
My issue is that when I make changes to the list boxes for State B - the state B chart also changes dynamically which can be misleading?
Can I rebase the State B chart axis to be equally to what it is for State A or vice verse?
Thanks very much for your help
(have tried to show a basic example below of my set up)
List boxes that drive List boxes that drive
State A selections State B selections
STATE A Chart STATE B CHART
Hi, have you tried using a bit of set analysis on the charts using the two states but making the"other" state an invisable line that way your scales will remain the same, i have attached an example
Hi, have you tried using a bit of set analysis on the charts using the two states but making the"other" state an invisable line that way your scales will remain the same, i have attached an example
100%
Thanks so much for taking the time to help me on this!
I have another Question that I would be grateful if you answered.
I have a pivot with a list of clients and stats beside them.
I want to permanently exclude a group of people (Tier A) from the pivot without having to make selections in the Tier list box.
What is the best way to go about this?
Client Tier $
Client A Tier A xx
Client B Tier A xx
Client C Tier B xx
Client D Tier B xx
Client E Tier C xx