You must Sign In to post a response.
  • Category: .NET

    How do I mange ColumnClustered thinckness in excel chart in c#.net programatically.

    How do I mange ColumnClustered thinckness in excel chart in c#.net programatically.

    Also chart thickness differ in different computers.
  • #764379
    Hi Vinod,

    1) You said that chart thickness differ in different computers: I think the factors affecting this will be the screen resolutions and microsoft word/excel versions at different computers.
    2) To manage thickness of Chart with ExcelChartType = ExcelChartType.ColumnClustered take care of following:

    UrChartObject.LeftColumn = 1;//.. Column from where chart starts
    UrChartObject.TopRow = 5; //... Row from where chart starts
    UrChartObject.RightColumn = 15 ;//.. Column where chart ends
    UrChartObject.BottomRow = 20; //... Row where chart ends
    UrChartObject.Legend.Position = LegendPositionType.Right;
    Or
    UrChartObject.Legends["Legend1"].Position = new ElementPosition(1, 5, 75, 50); //... ElementPosition takes 0 or 4 parameters as (X, Y, WIDTH, HEIGHT).

    Hope it helps.
    Regards,
    Shashikant Gurav
    shashikantgurav22@gmail.com


Sign In to post your comments