Preserve Chart Fomatting in Line Chart RRS feed

  • Question

  • I have a line chart where I have set the line formatting to be smoothed lines. I also have one line that I want to be a dotted line. I have code that deletes the source data for this chart and puts new data. I also have code to adjust a named range for the data and also adjust the chart to reflect the data in the named range. So far, so good. However, when the code runs, my chart loose the additional formatting. The lines go back to being angled and not smoothed and the dotted line reverts back to a single line.

    Is there a way to set my formatting for this chart and not loose it when the data is updated?


    Monday, May 6, 2013 6:40 PM

All replies

  • My solution was to add code to iterate through the seriescollection and set the line formatting back the way I wanted it. I guess this wil do, but I still would like to know if there is a better way.


    Monday, May 6, 2013 7:02 PM
  • Instead of deleting the series entirely can you change the series to point to the new data.

    Peter Thornton

    Tuesday, May 7, 2013 7:47 AM