Plotting Graph with dynamic table

C

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
 
C

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.
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top