Line selection for formating in Excel chart

  • Thread starter Thread starter DaveR
  • Start date Start date
D

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
 
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
 
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
 
Sorry, I didn't notice Andy's post before I responded, saying pretty much
the exact same thing.

- Jon
 
Thank you very much for your response... That works well for me... have
coworker using the latest (2007?) Vista looking MS Office. Same trick?
 
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
 
Back
Top