Plotting Graph with dynamic table

[CS Chia]

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

 

[Claus Busch]

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:
https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for "ChartTest"


Regards
Claus B.

 

[CS Chia]

Hi,

Am Fri, 28 Feb 2014 09:04:16 +0000 schrieb CS Chia:
-

please have a look:
http://tinyurl.com/n9s5tdh
for "ChartTest"


Regards
Claus B.

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

 

[Claus Busch]

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.