Hi


I have a table that displays data depending upon values that a user selects
from a control box.

Based on these values, a column chart is displayed.

My problem is...depending upon the value that the user selects from the
control box, the no. of columns of data to be plotted also changes.

If the user selects 1st value, there are 6 columns X 1 row. But if he
selects 2nd value, there are 9 columns X 1 row to be plotted in the graph.

The problem is, in the first case, the graph shows the first six columnar
chart but shows blank (empty column space) for the remaining 3.

Can you help me remove the empty 3 column space when the user selects 1st
value...There is no problem when the user selects the 2nd value.

Regards

Nikhil

Hi,

When you say the user picks from a "control box" what exactly are you using?
If you are using a combo box control then you already have code to display
or hide the items. Then you would just add code to hide the blank columns -
charts by default plot only visible cells.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Nikhil" wrote:

Hi


I have a table that displays data depending upon values that a user selects
from a control box.

Based on these values, a column chart is displayed.

My problem is...depending upon the value that the user selects from the
control box, the no. of columns of data to be plotted also changes.

If the user selects 1st value, there are 6 columns X 1 row. But if he
selects 2nd value, there are 9 columns X 1 row to be plotted in the graph.

The problem is, in the first case, the graph shows the first six columnar
chart but shows blank (empty column space) for the remaining 3.

Can you help me remove the empty 3 column space when the user selects 1st
value...There is no problem when the user selects the 2nd value.

Regards

Nikhil