Format data series (Chart)

[KRK]

Hello,

I know how to format a data series in a chart. I right-click on the data in
the chart, select 'format data series, no problem.

I want to format several series at the same time (eg line thickness, marker
colour). Is there a way of doing this ??

Thanks

KK

 

[Mike H]

Hi,

You can only select a single data series but you could use a macro.
Here's a sample one with a couple of format options

Sub FormatChart()
Dim r As Series
For Each r In ActiveChart.SeriesCollection
r.Border.Weight = xlThin
r.Shadow = True
Next
End Sub


Mike

 

[KRK]

Thanks for the help, can I ask a follow-up question. ?

I sometimes find it difficult to select the data series I want to format
(there are several on my plot)

After formatting one series, can I move to the next data series without
exiting the 'format' window, ie is there a keyboard sequence or trick ?

Thanks again

KK