Hi All,

I have written some VBA code which sorts a time series of data in ascending order of values, and utilises a 2D array. Now I have managed to get the sorted data into my 2D array and the array now stores values for e.g. as below:

ArrayOfSortedData

-1 30/09/2012
-2 31/01/2005
-3 28/02/2010
4 31/05/2008
5 31/05/2001
7 31/01/2011

Now I want to use this 2D array as source data for a histogram chart the series being called 'SortedTimeSeries' with Y axis values being the numbers and the X axis values being the dates. Any ideas how I can accomplish this?

Thanks