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

    Jun 3 ball
    Jul 5 ball
    aug 3 ball

    Scenario 2
    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. Advertisements

  2. CS Chia

    Claus Busch Guest

    Claus Busch, Feb 28, 2014
    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
  4. CS Chia

    Claus Busch Guest


    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.

    Claus B.
    Claus Busch, Mar 3, 2014
    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.