+ Reply to Thread
Results 1 to 3 of 3

How to automate the quarterly manual updating of over 100 graphs?

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    How to automate the quarterly manual updating of over 100 graphs?

    Hi Excel Forum,

    I have two Excel data sets (attached), one for Firm_1 and the other for Firm_2 which shows % distribution of customers in each financial quarter by loan delinquency cycles.

    In each quarter, I have to update the each of 3 graphs as new data are coming in.

    What I have been doing was this. I go to each graph, right click, then clik “select data”, then click “edit” and expand the data range to capture the newly arrived data points of new quarters.

    Q:
    I have over 100 graphs to do this exercise, which is strenuous and error prone. Would you please help me to automate the process to reduce the strain and the error of manual exercise.

    Thanks for your time and expertise.

    Mirisa
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,985

    Re: How to automate the quarterly manual updating of over 100 graphs?

    You could just set the range to be future proofed, this would give blank space at the right of the graph but would save a fair bit of work, even if you just expanded it by 4 rows each year it would reduce the work invovled for yourself to a quarter.

    Otherwise it would be possible to create the graphs using a VBA routine to establish how much data is available and set the source accordingly.

  3. #3
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: How to automate the quarterly manual updating of over 100 graphs?

    Hi pjwhitfield,

    Thanks.

    I have tried your suggestion.

    However, the graphs look unfinished with an undone space ahead.

    I wonder if my problem can be captured using pivot charts.
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically Update Quarterly Graphs
    By -Doug- in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-24-2014, 09:25 AM
  2. Replies: 2
    Last Post: 10-03-2012, 11:18 AM
  3. Replies: 0
    Last Post: 08-01-2012, 09:11 AM
  4. Automate Manual excel reporting using VBA
    By NKOTB_VBA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2011, 10:16 AM
  5. Need to automate this manual spreadsheet -- pls help
    By kilo94 in forum Excel General
    Replies: 5
    Last Post: 09-12-2006, 06:40 PM

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