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

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

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, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DaveR" wrote in message
...
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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
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

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

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, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DaveR" wrote in message
...
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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

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, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DaveR" wrote in message
...
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