Automatic, multiple charts using first column as X-axis

[Fr3dY]

Hi. I'm having big problems with something that might be very easy to do, although I tried (and searched how to do it) without success:

I've got a sheet, with 'Date/Time' as first column.
I can select it, along with any other column to insert a graphic chart into the worksheet and works fine.
My question is.... how can I make Excel generate automatically ONE CHART for each column, with 'Date/Time' as X axis? I tried some dynamic table/charts but it's incredibly messy (it's faster for me to create the charts one by one, manually!).


Thanks for your help.

 

[Steve=True]

In 2007, make it a Chart Template that you can choose in the Change Chart Type selectors by Selecting your chart, then select the design menu then select Save as Template.