Rickz, I have taken your Excel Data and placed it in an Access table, 2 queries one for the Subform and one for the Graph, created a background form, a Continuous Mode Subform to display the data and added a Chart to the background form based on the values in a Query of the Table.
There is a button on the background form that "Re-queries" the Chart, so that you can make changes to the values on the form and therefore in the table and reflect those changes in the Chart.
However the table, queries and form just used the values for "C(FORMULA OF A,B,C,D,E)" that you supplied as I just cannot make the Formula re-create anything even close to those values.
Reply With Quote
