Static Scale for two (alternate state) charts

[#1]

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

[sbaldwin · Accepted solution]

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

[#3]

100%

Thanks so much for taking the time to help me on this!

[#4]

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