Line selection for formating in Excel chart

[DaveR]

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]

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

 

[Jon Peltier]

If you're using Excel 2003 or earlier, you can select one series, apply some
formatting, then use the up/down arrow keys to select another series, and
press F4 to apply this formatting to the newly selected series. Using the
arrow/F4 combination, you can format a lot of series very quickly.

- Jon

 

[Jon Peltier]

Sorry, I didn't notice Andy's post before I responded, saying pretty much
the exact same thing.

- Jon

 

[DaveR]

Thank you very much for your response... That works well for me... have
coworker using the latest (2007?) Vista looking MS Office. Same trick?

 

[Jon Peltier]

Afraid not. In 2007 Microsoft introduced modeless dialogs, and an unintended
consequence of modeless dialogs is that the Undo (Ctrl+Z) and Repeat (Ctrl+Y
or F4) only remember the last individual formatting operation performed
during the trip to the dialog, not everything that was accomplished during
the trip.

I get around this by using code (but the macro recorder doesn't work for
this any more in 2007, because anything related to the new shape elements is
not recorded).

- Jon