Scale with negative values in Excel chart

Copper 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