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!

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

XY Scatter Chart in Access 2007 Form

Status
Not open for further replies.
Buckar00B0nzai

Buckar00B0nzai

Technical User
Jun 17, 2009
50
0
0
US
I have a form (Frm_Entry) whose record source is Tbl_Main. In that table and on that form, I capture a cumulative Benefit score and a cumulative Effort score in order to conduct a brief analysis for the work we might pursue. I want to display this data as a XY Scatter chart on the form. When I do insert a chart (from the toolbar option), it only allows for one column of data and one series name. The result is a XY scatter chart where the Y value is plotted (based on the "Benefit" score), but the X value (the "Effort" score) is always set to 1 (the actual value is closer to 8).

Can anyone help?

Buckaroo Banzai
 
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
85
Xavierparkash
Xavierparkash
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
122
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
85
TrekBiker
TrekBiker
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
204
dhookom
dhookom
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
63
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top