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
     
    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

    Claus Busch;1616472 Wrote:
    > Hi,
    >
    > Am Fri, 28 Feb 2014 09:04:16 +0000 schrieb CS Chia:
    > -
    > > How can I create a graph that can dynamically plot the data without
    > > having a big blank on the right side of the graph?-

    >
    > please have a look:
    > http://tinyurl.com/n9s5tdh
    > for "ChartTest"
    >
    >
    > Regards
    > Claus B.
    > --
    > Win XP PRof SP2 / Vista Ultimate SP2
    > Office 2003 SP2 /2007 Ultimate SP2



    Could you share your approach?
    How does the number of months field help in generating the chart


    --
    CS Chia
     
    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:

    > How does the number of months field help in generating the chart?


    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.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    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.