I have created a Chart Object. I have two dimensions listed to define my different X Axis labels. I also have created two expressions that when I choose the area in a listbox, that it displays the corresponding BarChart. When I do that, it attempts to put the entire range of values under one axis point. If I were to remove one of the dimensions, the one chart with the remaining dimensions, reads fine.
If I were to export the funky chart to excel, it shows its trying to use both dimensions at once as opposed to one or the other based on the selection.
Not sure what you want to achieve, but you can maybe look into using conditional dimensions, where the condition is based on selection. You can enable conditional dimensions on dimension tab.
The condition should return a boolean, something like
