+ Reply to Thread
Results 1 to 2 of 2

replace title

  1. #1
    Terry
    Guest

    replace title

    I have 15 excel files, except the basic numerical data, they almost identical
    (they are created from same template file by changing data set).
    Each file has 5 sheets and within each sheet, there are at lest 3 charts
    (total 20 in each file).

    Each chary has its own title.
    The first part of title is ID that is the unique for each excel file (all
    chart have same first part).

    When I creat new file with new ID I currectly change all title of charts
    manully.
    Is there any easy way to change text of chart title, when ALL THE CHART have
    SAME changing. Like replace command in tool bar.

  2. #2
    Tushar Mehta
    Guest

    Re: replace title

    You would have to write your own macro to change the titles of all the
    charts. However, it might be easier to link the title to a worksheet
    cell. Then, change the contents of that cell and the chart title will
    automatically change. To link a title to a cell see
    Dynamic Chart Title
    http://www.tushar-
    mehta.com/excel/newsgroups/dynamic_chart_title/index.html
    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <434F5277-16B4-42E4-939A-6CCCED7A5230@microsoft.com>,
    Terry@discussions.microsoft.com says...
    > I have 15 excel files, except the basic numerical data, they almost identical
    > (they are created from same template file by changing data set).
    > Each file has 5 sheets and within each sheet, there are at lest 3 charts
    > (total 20 in each file).
    >
    > Each chary has its own title.
    > The first part of title is ID that is the unique for each excel file (all
    > chart have same first part).
    >
    > When I creat new file with new ID I currectly change all title of charts
    > manully.
    > Is there any easy way to change text of chart title, when ALL THE CHART have
    > SAME changing. Like replace command in tool bar.
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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