Set Auto display unit in chart

Posted by: satson90 on 8 September 2017, 3:06 pm EST

  • Posted 8 September 2017, 3:06 pm EST

    Hi


    How to set auto display unit in chart like a excel chart display unit

  • Replied 8 September 2017, 3:06 pm EST

    Hello,

    You can set the DisplayUnits property of ValueAxis to
    set the auto display units for the chart. Please have a look at the
    following link that describes the same:

            http://helpcentral.componentone.com/NetHelp/SpreadNet6/WF/FarPoint.Win.Chart~FarPoint.Win.Chart.ValueAxis~DisplayUnits.html

    Hope it helps.

    Thanks,

    Manpreet Kaur
  • Replied 8 September 2017, 3:06 pm EST

    Hi kaur,


    Thanks for reply,


    plotArea.YAxes[0].DisplayUnits = 1000.0;


    I am changing the series value is dynamically so that also display unit is automatically set. above code is developer set by programatically but i don't want that


    Thanks


     

  • Replied 8 September 2017, 3:06 pm EST

    sathish_1990,

    In Excel (FormatAxis dialog | AxisOption tab), the value axis has a DisplayUnits combo box which has drop down values of {None, Hundreds, Thousands, ..., Trillions}. The combo box defaults to None. The combo box is editable so that user can also enter other positive numeric values.

    In Spread, the value axis has a DisplayUnits property which can be set to a positive numeric value. The property defaults to 1 (which is the same as DisplayUnits = None in Excel). Spread's DisplayUnits property works similar to Excel's DisplayUnits settings.

    I do not see a auto display units option in Excel. Am I missing something in Excel? Are you talking about a different feature in Excel? What version of Excel are you using?

  • Replied 8 September 2017, 3:06 pm EST

    Hi


    I am extermly sorry


    thanks for reply


     

Need extra support?

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

Learn More

Forum Channels