+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : add a chart template to excel quick access toolbar

  1. #1
    Registered User
    Join Date
    05-06-2004
    Posts
    4

    add a chart template to excel quick access toolbar

    Hi, I hope someone can help

    I have created a number of Excel chart templates (e.g. pie, line, bar) as our CEO likes all graphs to look a particular way on reporting.

    I want to add these templates as shortcuts on the quick access toolbar so any new chart I create can be changed to the template style with the click of a button.

    Is this possible? Ive noticed I can add the "Change Chart Type" command to the toolbar but I cant find a way to add the individual templates to the toolbar.

    PS I have the templates set as the default chart style but I want the option above too if possible.

    Thanks so much

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: add a chart template to excel quick access toolbar

    Not sure you can.
    You should though be able to add a macro command that applys the specific template to the active chart.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1