02 December, 2013

Set Up Default Chart In Excel

If you have a certain chart formatting you use often, you can set it as default. e.g. I don't like the border around the chart, and using grey as the chart background in Excel 2003 is just stupid and a waste of ink.
http://www.techrepublic.com/blog/microsoft-office/work-more-efficiently-by-changing-excels-chart-defaults/

  1. Set up a chart as you like it
  2. Click the chart, click the Design tab, Save As Template
  3. In the Insert tab, click the small arrow on the bottom right of the Charts section
  4. Click Templates in the left column, select your template and click Set as Default Chart

No comments:

Post a Comment