+ Reply to Thread
Results 1 to 2 of 2

automatically expand chart data series as data is added

  1. #1
    jlarson
    Guest

    automatically expand chart data series as data is added

    I have several time series charts thta I update for each business day. I
    would like the chart data series's to automaticallt expand as I add data.

  2. #2
    Andy Pope
    Guest

    Re: automatically expand chart data series as data is added

    Hi,

    You need to read up on dynamic named ranges.

    http://peltiertech.com/Excel/Charts/Dynamics.html
    http://www.tushar-mehta.com/excel/ne...rts/index.html
    http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm

    Cheers
    Andy

    jlarson wrote:
    > I have several time series charts thta I update for each business day. I
    > would like the chart data series's to automaticallt expand as I add data.


    --

    Andy Pope, Microsoft MVP - Excel
    http://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)

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