Plotting Graph with dynamic table

Discussion in 'Excel Charting' started by CS Chia, Feb 28, 2014.

  1. CS Chia

    CS Chia Guest

    I have a dynamic table where x-axis may not have all data to be plotted
    Scenario 1

    x
    Jun 3 ball
    Jul 5 ball
    aug 3 ball

    Scenario 2
    x
    Jun 3 ball
    Jul 3 ball
    Aug 3 ball
    Sep 8 ball
    Oct 7 ball

    How can I create a graph that can dynamically plot the data withou
    having a big blank on the right side of the graph

    As in the graph will create 3 months graph in scenario 1 and 5 month
    data in Scenario 2

    Please help
    Many thanks in advanc
     
    CS Chia, Feb 28, 2014
    #1
    1. Advertisements

  2. CS Chia

    Claus Busch Guest

    Claus Busch, Feb 28, 2014
    #2
    1. Advertisements

  3. CS Chia

    CS Chia Guest


    Could you share your approach?
    How does the number of months field help in generating the chart
     
    CS Chia, Mar 3, 2014
    #3
  4. CS Chia

    Claus Busch Guest

    Hi,

    Am Mon, 3 Mar 2014 01:43:22 +0000 schrieb CS Chia:
    the chart will be created by a named ranges. Look into the name manager
    to see how the months field changes the range.


    Regards
    Claus B.
     
    Claus Busch, Mar 3, 2014
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.