I have developed an application in MS Access 97. I have a query containing data. I need to get the Bin and Frequency values of this data. Once I have the Bin and Frequency values, I need to plot this information in a Histogram (graph).
I tried automating this in MS Excel 97. The data in the MS Access query is Transfered to a Spreadsheet using the TransferSpreadsheet action in the macro.
I then generate the Histogram in MS Excel 97.
I get the desired results but each time my data is updated in MS Access the Histogram (in MS Excel) is not updated. (The data in the worksheet is updated,though)
How would I determine the Bin and Freqency values in MS Access 97? Once I have these values how do I generate a Histogram using the Microsoft Graph 97 Chart?
Please help ..