Office JS Excel Chart Format

Question

To get chart, series, series point formatting, I have to load each format property (e.g axisGroup, gradient color etc).Is there any way we get chart, series and series point formatting is single function?

Answer 1

Hi,

Yes, there is a way to get the formatting for charts, series, and series point in a single function in Excel VBA. You can use the "With" statement to apply multiple formatting properties to a chart or series at once. For example:

With ActiveChart.SeriesCollection(1)
    .MarkerStyle = xlMarkerStyleCircle
    .MarkerSize = 8
    .Format.Fill.ForeColor.RGB = RGB(255, 0, 0)
End With

In this example, I have formatted the first series in the active chart by changing the marker style, marker size, and fill color all in one "With" statement.

Best Regards.