Results 1 to 3 of 3

Thread: Excel 2007 chart templates

  1. #1
    Join Date
    Apr 2009
    Posts
    13

    Excel 2007 chart templates

    hi
    i am newly working on Excel 2007 now i need help regarding Excel 2007 chart templates what is Excel 2007 chart templates and how to use it ?
    please help me
    thank you

  2. #2
    Join Date
    Apr 2008
    Posts
    4,088

    Re: Excel 2007 chart templates

    The Chart Template is good feature in charting Microsoft Excel. From a previously created chart you can save and reapply settings in chart template which allows a user quickly access. crtx files can be used in chart types. also template files contain setting for chart element and information with formatting .That provides settings such as line and fill properties, axis and element placement.

  3. #3
    Join Date
    Jan 2008
    Posts
    3,755

    Re: Excel 2007 chart templates

    Create and use Chart Template

    1. 1. Insert a chart to use as a starting point for your template. Note that chart templates can be created and used in any of the three Office applications that have the shared charting engine: Excel, PowerPoint, and Word.
    2. 2. Format the chart the way you normally would until the chart has the desired appearance. In my example I have made the following modifications to the chart:
      1. Applied a custom fill color to the series
      2. Deleted the legend
      3. Removed the horizontal axis line
      4. Set the horizontal axis maximum to 10
      5. Changed the line color of the gridlines and vertical axis line
      6. Reversed the categories order on the vertical axis
      7. Set the horizontal axis crosses at setting to maximum value
      8. Added a chart title and entered the title text
      9. Changed the chart titles font to be the same color as my series

    3. Save the chart template.

      1. With the chart selected, click on the Design tab in the Ribbon
      2. Click on the "Save As Template" button located in the Type chunk
      3. Enter a template name and click Save

    Note: Saving chart templates as standalone .crtx files is a new feature for Office 2007. By using standalone files, chart templates can easily be shared amongst different users. The saved template location for Windows Vista users is C:\Users\<user_name>\AppData\Roaming\Microsoft\Templates\Charts (C:\Documents and Settings\<user_name>\Application Data\Microsoft\Templates\Charts for Windows XP users). This folder location can also be found using the "Manage Templates…" button in the Chart Type dialog. Once a template file is saved in this folder it can be accessed and applied in any of the three charting applications.
    now for more to Use a chart template check here

Similar Threads

  1. How to add straight line in a chart in Excel 2007
    By Nyota in forum MS Office Support
    Replies: 1
    Last Post: 25-02-2012, 12:06 PM
  2. Help needed to add a Chart with a macro in Excel 2007
    By Clemens in forum Windows Software
    Replies: 3
    Last Post: 19-11-2010, 12:31 AM
  3. export gantt chart from Project 2007 to Excel
    By hatred in forum Microsoft Project
    Replies: 6
    Last Post: 16-11-2009, 09:37 PM
  4. Hiding zero values on a chart in Excel 2007
    By mellisahi in forum Windows Software
    Replies: 4
    Last Post: 12-11-2009, 09:37 AM
  5. How to lock Chart in Excel 2007
    By Durjaya in forum Windows Software
    Replies: 3
    Last Post: 08-05-2009, 03:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,722,725.42195 seconds with 17 queries