LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Quickly Format Multiple Data Series in One chart

In Excel 2007, if all you are changing is one single attribute of a series
(such as line weight), you can format one series, then select each
additional series and press the F4 key to repeat the formatting. (In Excel
2003 you could use F4 to repeat everything you did in a trip to the
formatting dialog, but whatever.)

Once you format a chart the way you like it, you can save the chart as a
template. The button is on the left side of the Chart Tools Design tab. You
can then apply the template through the Change Chart Type dialog, which has
a folder called Templates at the top of the list of chart types.

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


"Jeff Meeusen" wrote in message
...
I do a lot of charts that contain spectral data. I'll have 20-30 data
series
and I plot them as a XY scatter using the line only format. However the
default thickness in XL 2007 is way too fat and consequently I loose any
ability to differentiate the series. So far the only way I've been able
to
change this is by actually selecting each individual series and changing
the
thickness. Is there a way to change the default line thickness to 1/2 pt?
Or at least to change all the series in a chart in one go?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to chart series data from multiple rows in a table? Don F. Charts and Charting in Excel 7 June 3rd 08 07:39 PM
Format Data Series in a Chart Jennifer Excel Worksheet Functions 4 May 22nd 07 08:22 PM
Pivot Chart - multiple Data series Andy Charts and Charting in Excel 4 January 5th 07 05:39 PM
How can I create a chart to compare multiple data series? magnoliak77 Charts and Charting in Excel 2 July 2nd 06 02:01 AM
Create multiple data series for a chart in one shot... ronbrosh111 Charts and Charting in Excel 5 June 6th 06 06:16 PM


All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"