Aug 31 2021 12:33 AM
Hi everybody. I have to doubts concerning pivot charts.
1. Is there a way to block the axes (especially the x-axis) in a pivot chart? I have a histogram and I am reporting data belonging to two different classes. Let's say e.g. data stay in range (150; 350). When I filter for just one of these two classes data only belong to (300; 350) so the x-axis format changes to that interval. I would like to keep the x-axis range to (150;350) even when filtering cause I want to have an immediate "visual" comparison with those data. Is there a chance to have this? I know it is possible with a standard histogram, but now I have a pivot histogram and I don't manage to reach it.
2. Still talking about pivot histograms, is there a way to set manually (and not authomatically!) the length of ranges represented in the x-axis? I want bars referring to (10;20), (20;30), (30;40) while the chart authomatically sets each bar corresponding to a single unit. Again, this can be easily done in a standard histogram, but the pivot histogram doesn't manage to do that.
Thanks to everyone!
Aug 31 2021 03:48 AM