Pivot Chart Y Axis not auto formatting range

%3CLINGO-SUB%20id%3D%22lingo-sub-2651374%22%20slang%3D%22en-US%22%3EPivot%20Chart%20Y%20Axis%20not%20auto%20formatting%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2651374%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20slicer%20running%20a%20pivot%20table%20and%20linked%20chart%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%208%20of%20the%20selections%20the%20Y%20Axis%20range%20function%20(auto)%20is%20working%20fine%20%2C%20but%20for%202%20NOT%20.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20show%20the%20pics%20of%20two%20different%20ones%20%2C%20the%20faulty%20one%20is%20set%20to%20minimum%200%20.%20There%20is%20a%20greyed%20out%20cell%20that%20if%20not%20filled%20seems%20to%20make%20the%20min%20zero%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22shotgun68_0-1629100208119.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303509iECB67DBA953201D7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22shotgun68_0-1629100208119.png%22%20alt%3D%22shotgun68_0-1629100208119.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%20Bad%20one%20with%20zero%20value%20as%20Min%2C%20to%20be%20clear%20no%20pivot%20table%20values%20are%20zero%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22shotgun68_1-1629100237464.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303510i50D792E78CD8F8A4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22shotgun68_1-1629100237464.png%22%20alt%3D%22shotgun68_1-1629100237464.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3BGood%20one%20with%20correct%20range%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2651374%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I have a slicer running a pivot table and linked chart 

 

For 8 of the selections the Y Axis range function (auto) is working fine , but for 2 NOT . 

 

I show the pics of two different ones , the faulty one is set to minimum 0 . There is a greyed out cell that if not filled seems to make the min zero 

 

shotgun68_0-1629100208119.png  Bad one with zero value as Min, to be clear no pivot table values are zero 

shotgun68_1-1629100237464.png Good one with correct range 

 

 

0 Replies