Hello,
I have a columns of data that I have been able to automate into creating
charts for each, and thought it would be nice to be able to include the
minimum, maximum, and average value of that column in the chart legend. I
have two places that I am stuck at (at least at this point)!
1. I have figured out that I can use Excel functions as follows:
varMINValue = objExcelApp.MIN()
But how can I specify the used range of cells in a column in the MIN brackets?
2. How do I get these Excel function values into the the chart legend?
I found the following link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/xlobjLegendEntry.asp
But I am stuck as to how I can assign a legend key a value.
Any help you can give would be most appreciated!
Thanks!