Mini chart not working

[Luis_C]

I have this problem with mini charts.... for some reason sometimes the charts are out of proportion internally. Try this example:

Insert in 5 cells across these values 6 3 3 4 5 and the insert a bar minichart. The bars corresponding to the numbre 3 are out
of proportion.

I have an image here...

https://www.dropbox.com/s/20knwze1hgeqrwi/Minichart.png?dl=0

Thanks...

Luis

 

[thisoldman]

With the cell containing the sparkline chart selected, go to the "Design" tab on the ribbon. Click on "Axis", then under "Vertical Axis Minimum Value" click on "Custom Axis...", and enter zero.

 

[Luis_C]

With the cell containing the sparkline chart selected, go to the "Design" tab on the ribbon. Click on "Axis", then under "Vertical Axis Minimum Value" click on "Custom Axis...", and enter zero.

Thank you very much, old man... this solved my problem. I think it is an odd behaviour of the minichart tool anyway....

Luis

 

[thisoldman]

You're welcome.

Yes it's not only odd behavior it's bad behavior: columns and bars should begin at zero.