Hi,

I have written a macro to format data in an Excel spreadsheet (365 lines of data with a dates in column 1 followed by 48 columns of numeric data). What I would now like to do is show the data in a thumbnail graph similar to the 'Click to see preview' in Excel charting. The graph does not have to be sophisticated, it is the shape I am interested in not the individual values. All ideas welcome, because I'm well and truly stuck.

Many thanks.

the easiest way is to use the MSChart control:

http://msdn.microsoft.com/library/de...hartobject.asp

Marco