none
Sparkline Misrepresenting Data RRS feed

  • Question

  • Has anyone else seen this problem? Is there a solution?

    Below is the actual data in a range which I've added a sparkline (column) to represent.  Notice that the 3rd & 4th columns appear to be almost zero (0) even though the actual value is about half of the average; so the columns are misrepresenting their values.

    Data:

    44
    46
    20
    20
    46
    33
    39
    45
    41
    49
    43

    37

    Sparkline Image


    Ross

    Thursday, March 12, 2015 3:16 PM

Answers

  • The Sparkline is using the minimum value in the data set as the zero point for the vertical axis.  To set a different minimum value:

    Select the Sparkline

    On the Ribbon, click the Design tab under Sparkline Tools

    In the Group section, click Axis

    Under Vertical Axis Minimum Value Options, choose Custom Value...

    Set the desired minimum value for the vertical axis, and then click OK.



    • Edited by Mark18991230 Thursday, March 12, 2015 5:23 PM
    • Marked as answer by T3mplar Thursday, March 12, 2015 6:06 PM
    Thursday, March 12, 2015 5:08 PM

All replies

  • The Sparkline is using the minimum value in the data set as the zero point for the vertical axis.  To set a different minimum value:

    Select the Sparkline

    On the Ribbon, click the Design tab under Sparkline Tools

    In the Group section, click Axis

    Under Vertical Axis Minimum Value Options, choose Custom Value...

    Set the desired minimum value for the vertical axis, and then click OK.



    • Edited by Mark18991230 Thursday, March 12, 2015 5:23 PM
    • Marked as answer by T3mplar Thursday, March 12, 2015 6:06 PM
    Thursday, March 12, 2015 5:08 PM
  • Thank you, so much!

    Ross

    Thursday, March 12, 2015 6:06 PM