Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Plot a graph automatically...

Status
Not open for further replies.

ViAn

Technical User
May 7, 2003
30
NO
This is what I do now:

1) In a datasheet in a form displaying the results of a direct ODBC-query I click one of the column headers to mark a column.
2) I push "Ctrl-C" to copy the data.
3) I open a form including a chart in Design View.
4) I dobule-click the chart to get the datasheet of the chart.
5) I mark all the contents of the datasheet and push "Delete".
6) I mark the column header with name "A".
7) I push "Ctrl-V" to paste the data.
8) The chart now appears just like I would like it!!!
9) I try to save and then choose View ="Form View".
10) My changes disappear!

This is what I would like to do:
1) [See above]
2) Push a button to see a plot of the column data!

Some VBA-coding will be necessary to make this happen. Do anyone know how to do this? (Or/And how to plot manually in a more successful and easier way than that described above?)

Thank you!

Yours S. ViAn
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top