Format data series (Chart)
 

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

Format data series (Chart)
 

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" wrote:

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

.

Format data series (Chart) - Thanks & a follow-up Q please
 

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


"Mike H" wrote in message
...
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" wrote:

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

.