Sparklines

[mr_hiboy]

Evening all,


Anyone else have issues with sparklines not showing similar values in a relevant fashion.


i.e. i have two values, 8% and 9%. The two column sparkline shows one about 2 pixels in height and one about 100 pixels high.


You'd expect there to be little difference or at worst a slightly exaggerated difference.


thoughts?

 

[SirJB7]

Hi, mr_hiboy!

At a first glance, should be values displayed as 8% and 9% but actually containing 8% and 109%? If not, any chance uploading the sample file?

Regards!

 

[mr_hiboy]

Here you go...crack it

https://dl.dropboxusercontent.com/u/9071274/Sparkline.xlsx

 

[SirJB7]

Hi, mr_hiboy!


Try adjusting the min and max vertical y-axis values from Automatic to Custom and set them to 0 (zero) and 0.1 (10%). Select the sparklines chart and from the Sparklines Tools click on Axis.


Regards!

 

[mr_hiboy]

Great - took a little tinkering as the chart is dynamic based on dropdown selection so percentage vary from -40% to >100%


Definitely look better!


Cheers

Paul

 

[SirJB7]

Hi, mr_hiboy!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!