none
How to set line colors in an Excel chart 2016 RRS feed

  • Question

  • Hi,

    I have a Excel VSTO add-in application (Visual Studio 2010 VB.net) that creates a line chart and sets colors for the lines. This application works fine on Excel 2010/2013, but the line colors and the lines dash styles cannot be set in Excel 2016; the chart is always created with default lines color and default lines dash styles. Did anyone experience the same problem?

    Below you’ll find my code to set line colors and dash styles:

    With ZSeries.Format.Line

    .Visible = Microsoft.Office.Core.MsoTriState.msoTrue

    .ForeColor.RGB = RGB(255, 0, 0)

    .DashStyle = Microsoft.Office.Core.MsoLineDashStyle.msoLineSysDash

    End With

    Thanks for helping me!

    George Sun

    Tuesday, February 2, 2016 7:58 PM

All replies

  • Hi George Sun,

    This is the forum to discuss questions and feedback for Microsoft Excel, I'll move your question to the MSDN forum for Excel

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    Regards,

    Emi Zhang
    TechNet Community Support


    Please mark the reply as an answer if you find it is helpful.

    If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Wednesday, February 3, 2016 6:04 AM
  • Hi George,

    Based on my test in VS2010 with excel 2016, it works fine.

    I shared it on the OneDrive.

    http://1drv.ms/1QHqekp

    Please check it and post the result here.

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, February 4, 2016 7:02 AM
    Moderator
  • Hi,

    Do you solve that issue? Anything update will be appreciated.

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, February 9, 2016 8:43 AM
    Moderator