Charts multiplication

  • Thread starter Thread starter Valdi
  • Start date Start date
V

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.
 
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.
Click to expand...
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
 
Back
Top