Chart

Posted by: kamalkishore on 10 September 2017, 10:56 am EST

  • Posted 10 September 2017, 10:56 am EST

    Hello


    I want to drow chart like Waterfall chart(as like attached screen shot) .Can we drow chart's in sparkline. If it is possible please give some sample code for it.


     


    2012/08/Chart.GIF
  • Replied 10 September 2017, 10:56 am EST

    Hello,

    You may create a Sparkline chart as WinLoss type. Please have a look at the attached sample application.

     

    Thanks,

     

     

     


    2012/08/SpreadSLSparkLine.zip
  • Replied 10 September 2017, 10:56 am EST

    Hello,

    Please, check the attachment. I need to implement the sparkline chart in same way in spread sheet. So, the related questions are -
    1. Can we have multiple y-axes, with different scaling as shown in image - Like in thousands for 1 y-axis & upto 100 for other? Accordingly, the range will differ, as available length of axis will get divided & set the range automatically. Not a big deal, even if we have to set the range.
    2. Can we have axis lablels for both x & y-axis, to show the ranges? Along with that can we have another lable, as shown in figure for right y-axis, it is "%".
    3. For x-axis, if the space is not sufficient for displaying axis lables, can we rotate the lables - i.e. the years on x-axis 2007, 2008 - to verticle or inclined?
    4. Can we show the legends as shown at the bottom of the image?
    5. Can we have tooltip for marker points?
    6. Can we add the multiple line series for same cell range with different data? I tried with SparklineGroup, but cannot get it exactly. Please, provide the   example.

    Thanks,
    Pragati.


    2012/08/Multiple Y-axes.JPG
  • Replied 10 September 2017, 10:56 am EST

    Hello,

    I don't think we can make all these settings with Sparklines. We can only do these  things with a chart controls. There are no Legends, Labels, Axis classes available with SparkLines to make changes to.

     

    Thanks,

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels