Data Series Markers

W

Wavequation

I have a graph with a large number of series. I would like to make all of
the data markers the same. Is there a way I can change them all as a group,
rather than one by one?
 
J

Jon Peltier

You can't change all series as a group, but if you're not using Excel 2007,
you can format one series, then select another and press F4 to repeat the
formatting, and repeat until you're done. An easy way to cycle through all
the series is with the up and down arrow keys.

Excel 2007 has lost the F4 capability in many cases, but you could still do
this programmatically.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top