Adjust chart scale when filtered by clicking on other chart
Let's say I have two charts: one is a column chart that shows sales by date, the other one - is a bar (or column or pie) chart that shows sales by Product.
The second chart is not filtered by date so initially it shows bars for all the sales of each product.
When I click on a column (that represents sales of a certain day) on the first chart, the second chart changes to represent product sales on that particular date. But the problem is that it KEEPS THE SCALE OF THE ORIGINAL chart. So that I almost cannot see the bars (or pie slices)
Please fix so that the scale will adjust automatically
Chee-Wee Chong commented
I have the same problem. I need the map scale the same no matter what filter I applied to. Please help.