View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Line selection for formating in Excel chart

Hi,

No you can not select multiple series, like you can with shape objects.

The only time saver is, select 1 on the series and the format just the
line thickness. You can now use the Up and Down arrows to cycle through
the chart elements, namely the series. When you move on to a series
press F4, this will repeat changes on the selected series.

Cheers
Andy

DaveR wrote:
Have "plain vanilla" line chart in excel spread sheet. Data series consist of
several lines closely space. Normally I can select and RClick a single series
for formating such as line color and thickness. Is it possible to
simultaneously select all data series to change a common format such as line
thickness. I'd like to do this without individually selecting each line while
the control key is depressed. (lazy and not that good-a shot). ~Dave


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info