Scale with negative values in Excel chart

%3CLINGO-SUB%20id%3D%22lingo-sub-2909607%22%20slang%3D%22en-US%22%3EScale%20with%20negative%20values%20in%20Excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2909607%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20making%20a%20Pareto%20chart%20(ABC%20Chart)%2C%20but%20when%20changing%20the%20maximum%20and%20minimum%20limits%20of%20the%20values%20(R%24)%20it%20ends%20up%20showing%20a%20negative%20value%20and%20I%20would%20like%20it%20to%20start%20at%20R%24%20-%20(R%24%200.00).%20How%20can%20I%20fix%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Picture.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F322310i638071ED699F0855%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Picture.png%22%20alt%3D%22Picture.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EArchive%20on%20OneDrive%3A%26nbsp%3B%3CA%20title%3D%22Exercise%20saved%20in%20OneDrive%22%20href%3D%22https%3A%2F%2F1drv.ms%2Fx%2Fs!AnRoIqk1QPtihJBZAyMhGNsXfuJtXw%3Fe%3DKN9ufa%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExercise%3C%2FA%3E%3C%2FFONT%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2909607%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2909973%22%20slang%3D%22en-US%22%3ERe%3A%20Scale%20with%20negative%20values%20in%20Excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2909973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F906783%22%20target%3D%22_blank%22%3E%40bsabrunosouza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EClick%20over%20the%20axis%20you%20want%20to%20setup%20and%20manually%20insert%20the%20mininum%20you%20want%20to%20show.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JulianoPetrukio_1-1635791293549.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F322405i91C258C975E89ABA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JulianoPetrukio_1-1635791293549.png%22%20alt%3D%22JulianoPetrukio_1-1635791293549.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2909983%22%20slang%3D%22en-US%22%3ERe%3A%20Scale%20with%20negative%20values%20in%20Excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2909983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40Juliano-Petrukio%3C%2FA%3EBy%20doing%20this%2C%20the%20scale%20value%20is%20limited%20(even%20with%20the%20values%20being%20entered%20manually)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22bsabrunosouza_0-1635791515163.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F322408i4BAE113EA58048B6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22bsabrunosouza_0-1635791515163.png%22%20alt%3D%22bsabrunosouza_0-1635791515163.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, I'm making a Pareto chart (ABC Chart), but when changing the maximum and minimum limits of the values (R$) it ends up showing a negative value and I would like it to start at R$ - (R$ 0.00). How can I fix this?

Picture.png

 

Archive on OneDrive: Exercise 

2 Replies

@bsabrunosouza 

Click over the axis you want to setup and manually insert the mininum you want to show.

JulianoPetrukio_1-1635791293549.png

 

@Juliano-PetrukioBy doing this, the scale value is limited (even with the values being entered manually)

 

bsabrunosouza_0-1635791515163.png