How to modify axes in a pivot chart?

%3CLINGO-SUB%20id%3D%22lingo-sub-2759453%22%20slang%3D%22en-US%22%3EHow%20to%20modify%20axes%20in%20a%20pivot%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2759453%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-subject-wrapper%20lia-component-subject%20lia-component-message-view-widget-subject-with-options%22%3E%3CSPAN%3EHi%20everybody.%20I%20have%20to%20doubts%20concerning%20pivot%20charts.%20To%20explain%20them%2C%20I%20attached%20an%20Excel%20file%20to%20this%20post.%20It%20is%20composed%20by%20two%20sheets%3A%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-message-subject-wrapper%20lia-component-subject%20lia-component-message-view-widget-subject-with-options%22%3E%3CSPAN%3E-%20the%20Main_Sheet%20which%20is%20the%20main%20table%20containing%20the%20analysed%20data%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-message-subject-wrapper%20lia-component-subject%20lia-component-message-view-widget-subject-with-options%22%3E%3CSPAN%3E-%20the%20Pivot_Chart%20which%20contains%20the%20pivot%20histogram%20I%20want%20to%20apply%20some%20changes.%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20my%20doubts%3A%3C%2FP%3E%3CP%3E1.%20Is%20there%20a%20way%20to%20%22block%22%20the%20axes%20(especially%20the%20x-axis)%20in%20a%20pivot%20chart%3F%20E.%20g.%20the%20Pivot_Chart%20histogram%20x-axes%20range%20is%20from%203%20to%209.%20If%20I%20filter%20for%20Person%20%3D%20Max%2C%20it%20changes%20form%203%20to%206%2C%20while%20if%20I%20filter%20for%20person%20%3D%20Scott%20I%20get%20it%20from%206%20to%209.%20Is%20there%20a%20way%20for%20getting%20the%20x-data%20from%203%20to%209%20even%20if%20I%20filter%3F%26nbsp%3BI%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%20would%20like%20to%20have%20data%20counted%20in%20pairs%2C%20meaning%20that%20I'd%20like%20the%20x-axis%20to%20have%20ranges%20and%20not%20single%20values%20(e.g.%20if%20I%20filter%20the%20chart%20for%20person%20%3D%20Max%20I'd%20like%20to%20get%20(3%2C%204)%20and%20(5%2C%206)%20in%20the%20x-axis%20and%204%20and%203%20corresponding%20values.%26nbsp%3BAgain%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%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2759453%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2759620%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20modify%20axes%20in%20a%20pivot%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2759620%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1142050%22%20target%3D%22_blank%22%3E%40LM_950212%3C%2FA%3E%26nbsp%3BI%20believe%20that%20is%20not%20possible.%20But%20a%20workaround%20could%20be%20to%20include%20an%20extra%20column%20with%20the%20Labels%20and%20a%20set%20of%20dummy%20scores%20with%20no%20values%20for%20each%20person.%20Perhaps%20not%20feasible%20if%20you%20are%20dealing%20with%20lots%20of%20data%20%2F%20individuals.%20A%20working%20example%20is%20included%20on%20the%20Main%20sheet%20in%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi everybody. I have to doubts concerning pivot charts. To explain them, I attached an Excel file to this post. It is composed by two sheets: 
- the Main_Sheet which is the main table containing the analysed data;
- the Pivot_Chart which contains the pivot histogram I want to apply some changes.

 

Here are my doubts:

1. Is there a way to "block" the axes (especially the x-axis) in a pivot chart? E. g. the Pivot_Chart histogram x-axes range is from 3 to 9. If I filter for Person = Max, it changes form 3 to 6, while if I filter for person = Scott I get it from 6 to 9. Is there a way for getting the x-data from 3 to 9 even if I filter? 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 would like to have data counted in pairs, meaning that I'd like the x-axis to have ranges and not single values (e.g. if I filter the chart for person = Max I'd like to get (3, 4) and (5, 6) in the x-axis and 4 and 3 corresponding values. 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

@LM_950212 I believe that is not possible. But a workaround could be to include an extra column with the Labels and a set of dummy scores with no values for each person. Perhaps not feasible if you are dealing with lots of data / individuals. A working example is included on the Main sheet in the attached file.