Automated chart

[vinayanep]

Hi,

I have modified the the sample data and query. Kindly refer to

Automation should work as follows:
> Summary data gets updated based on the entry in sheet-'input'
> When the user enters a new process "F" relevent fields in 'input', chart need to be expanded to inlcude the new process 'F'
> We cannot remove or add any row


Thank you in anticipation.

-Vinayan

[Greg M]

Hi there,

See if the attached workbook does what you need.

The chart for the full amount of data is displayed, but the traces are not "messed up" by the absence of future data.

It's possible to do what you ask - i.e. to have the chart expand automatically each time new data are entered, but this requires a VBA solution.


Hope this helps - please let me know how you get on.

Regards,

Greg M