Charts multiplication

[Valdi]

I have dataset which contains various chemical parameters in columns.
I need a chart with changes each parameter in time.
It's easy, to make charts, by hand, one after one.
But when number of columns is great, it becomes borning
So... Is there any possibility to automatize this process ?
I mean everything stays, and only column is changing on every next chart.

Any ideas ??

Thanks in advance.

 

[Tushar Mehta]

I have dataset which contains various chemical parameters in columns.
I need a chart with changes each parameter in time.
It's easy, to make charts, by hand, one after one.
But when number of columns is great, it becomes borning
So... Is there any possibility to automatize this process ?
I mean everything stays, and only column is changing on every next chart.

Any ideas ??

Thanks in advance.

Take a look at XL's Data | Table... capability. Use one table to
change the values in one column and plot one graph per table.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions