+ Reply to Thread
Results 1 to 4 of 4

Dynamic Chart/How to

  1. #1
    SU
    Guest

    Dynamic Chart/How to

    I am trying to plot a dynamic chart and would appreciate your help. I have
    tried the methods specified in previous answers but due to my limited
    knowledge have so far failed.

    I am plotting a column chart with have 6 columns of Y-axis data and each
    column is 20 rows long but only populated till the 11th row.

    I would like the chart to dynamically expand when I add this data.

    My X-axis column is 3 column away from my first Y-axis column.

    Every Y-axis column has a header which I am using as a series name.

    Please help. Many thanks in advance.



  2. #2
    John Mansfield
    Guest

    RE: Dynamic Chart/How to

    SU,

    Perhaps these references that describe techniques of dynamic charting can
    help:

    http://pubs.logicalexpressions.com/P...cle.asp?ID=518

    http://pubs.logicalexpressions.com/P...cle.asp?ID=246

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com


    "SU" wrote:

    > I am trying to plot a dynamic chart and would appreciate your help. I have
    > tried the methods specified in previous answers but due to my limited
    > knowledge have so far failed.
    >
    > I am plotting a column chart with have 6 columns of Y-axis data and each
    > column is 20 rows long but only populated till the 11th row.
    >
    > I would like the chart to dynamically expand when I add this data.
    >
    > My X-axis column is 3 column away from my first Y-axis column.
    >
    > Every Y-axis column has a header which I am using as a series name.
    >
    > Please help. Many thanks in advance.
    >
    >


  3. #3
    Tushar Mehta
    Guest

    Re: Dynamic Chart/How to

    You may also want to check
    Dynamic Charts
    http://www.tushar-mehta.com/excel/ne...rts/index.html
    --
    Regards,

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

    In article <EE228F35-1C3E-4DCC-9F00-DC8C0CF43448@microsoft.com>,
    SU@discussions.microsoft.com says...
    > I am trying to plot a dynamic chart and would appreciate your help. I have
    > tried the methods specified in previous answers but due to my limited
    > knowledge have so far failed.
    >
    > I am plotting a column chart with have 6 columns of Y-axis data and each
    > column is 20 rows long but only populated till the 11th row.
    >
    > I would like the chart to dynamically expand when I add this data.
    >
    > My X-axis column is 3 column away from my first Y-axis column.
    >
    > Every Y-axis column has a header which I am using as a series name.
    >
    > Please help. Many thanks in advance.
    >
    >
    >


  4. #4
    Ed Ferrero
    Guest

    Re: Dynamic Chart/How to

    And, finally, if you don't want to remember all the OFFSET syntax and would
    rather let a wizard create dynamic ranges for you -
    http://edferrero.m6.net/Content/EFutil.zip

    Ed Ferrero



+ 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