How to modify axes ranges in a pivot chart?

%3CLINGO-SUB%20id%3D%22lingo-sub-2701550%22%20slang%3D%22en-US%22%3EHow%20to%20modify%20axes%20ranges%20in%20a%20pivot%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2701550%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everybody.%20I%20have%20to%20doubts%20concerning%20pivot%20charts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Is%20there%20a%20way%20to%20block%20the%20axes%20(especially%20the%20x-axis)%20in%20a%20pivot%20chart%3F%20I%20have%20a%20histogram%20and%20I%20am%20reporting%20data%20belonging%20to%20two%20different%20classes.%20Let's%20say%20e.g.%20data%20stay%20in%20range%20(150%3B%20350).%20When%20I%20filter%20for%20just%20one%20of%20these%20two%20classes%20data%20only%20belong%20to%20(300%3B%20350)%20so%20the%20x-axis%20format%20changes%20to%20that%20interval.%20I%20would%20like%20to%20keep%20the%20x-axis%20range%20to%20(150%3B350)%20even%20when%20filtering%20cause%20I%20want%20to%20have%20an%20immediate%20%22visual%22%20comparison%20with%20those%20data.%20Is%20there%20a%20chance%20to%20have%20this%3F%20I%20know%20it%20is%20possible%20with%20a%20standard%20histogram%2C%20but%20now%20I%20have%20a%20pivot%20histogram%20and%20I%20don't%20manage%20to%20reach%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Still%20talking%20about%20pivot%20histograms%2C%20is%20there%20a%20way%20to%20set%20manually%20(and%20not%20authomatically!)%20the%20length%20of%20ranges%20represented%20in%20the%20x-axis%3F%20I%20want%20bars%20referring%20to%20(10%3B20)%2C%20(20%3B30)%2C%20(30%3B40)%20while%20the%20chart%20authomatically%20sets%20each%20bar%20corresponding%20to%20a%20single%20unit.%20Again%2C%20this%20can%20be%20easily%20done%20in%20a%20standard%20histogram%2C%20but%20the%20pivot%20histogram%20doesn't%20manage%20to%20do%20that.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20to%20everyone!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2702294%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20modify%20axes%20ranges%20in%20a%20pivot%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2702294%22%20slang%3D%22en-US%22%3EThis%20board%20is%20for%20things%20related%20to%20Microsoft%20Learn%20and%20Microsoft%20Certifications.%20I%20would%20recommend%20reaching%20out%20on%20the%20Microsoft%20Excel%20Community%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

1 Reply
This board is for things related to Microsoft Learn and Microsoft Certifications. I would recommend reaching out on the Microsoft Excel Community https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat