Creating a chart template

  • Thread starter Thread starter CEGavinMcGrath
  • Start date Start date
C

CEGavinMcGrath

I have created a chart that I would like to use to analysis financial
information. The chart is derived from an 8-column-wide table of data (with
the number of rows depending on the amount of data that I wish to analyse).
I would now like to be able to use this same chart for any further data
tables that I create. Is there a way to,say, highlight a data series and
create a chart in exactly the same format?

Thanking you in advance.
 
Select a formatted chart you like then Chart>Chart Type>Custom Types>User
Defined.

Your selected Chart will be shown.

Click Add to add it to a list of user defined charts.

You can also make it the default "new chart" should you choose.

It will be saved into a file named XLUSRGAL.xls


Gord Dibben MS Excel MVP
 

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

Similar Threads

Pivot Table Chart? 4
How to create a bubble chart with more than 2 variables 0
PowerPoint Embed scroll excel chart and data in powerpoint 0
Charting: Multiple workbooks one chart 3
Office Excel 2007 Pivot Data Charting 2
Set chart series endpoint dynamically 0
Some chart types cannot be combined... 1
Creating a chart with varying data value ranges 1

Back
Top