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

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.
Similar Threads
  1. Annoyed by Excel

    Graph not plotting what it should be plotting

    Annoyed by Excel, Sep 4, 2003, in forum: Excel Charting
    Replies:
    2
    Views:
    273
    Jon Peltier
    Sep 5, 2003
  2. Timboi

    plotting simple XY axis graph

    Timboi, Nov 6, 2003, in forum: Excel Charting
    Replies:
    5
    Views:
    118
    Jon Peltier
    Nov 7, 2003
  3. breegeek

    plotting multiple x y data on same graph

    breegeek, Feb 8, 2004, in forum: Excel Charting
    Replies:
    1
    Views:
    135
    Bernard Liengme
    Feb 8, 2004
  4. Gonzalo Garreton

    Plotting a 2 sets of Y data in the X-Y same graph

    Gonzalo Garreton, Sep 24, 2004, in forum: Excel Charting
    Replies:
    1
    Views:
    134
    Bernard Liengme
    Sep 24, 2004
  5. kaifai

    Plotting a time graph

    kaifai, Oct 25, 2004, in forum: Excel Charting
    Replies:
    1
    Views:
    93
    Jon Peltier
    Oct 25, 2004
  6. sslack

    Plotting Line Graph of Dynamic Data

    sslack, Jun 5, 2005, in forum: Excel Charting
    Replies:
    1
    Views:
    173
    Tushar Mehta
    Jun 6, 2005
  7. Sanjay Kumar Singh
    Replies:
    1
    Views:
    359
    Tushar Mehta
    Jan 3, 2006
  8. Replies:
    2
    Views:
    273
Loading...