FORM CHARTS

[Kim296]

RE: ACCESS FORM

Is it possible to base a chart strictly on unbound form fields? I've created a form template which allows simple calculations, using (2 columns with 12 rows) equating to 24 unbound fields, that I wish to chart. The unbound field calculations work perfectly; however, I'm unable to figure out a way to create a chart based on the results. If I were in Excel, I could simply highlight the two columns and 12 rows to create the chart, but it doesn't work the same in Access.

Does anyone know how I can accomplish this task or if it's even possible using an unbound access form and fields?

Thank you,
Kim

 

[dhookom]

I doubt this is possible other than to put your values into a union query like which can be used as the Row Source property of the chart:

SELECT "West" as Direction, 3 as Num from msysobjects 
union 
SELECT "East", 4 from msysobjects 
union  
SELECT "South", 6 from msysobjects 
union 
SELECT "North", 1 from msysobjects

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Kim296]

Thank you very much for your response.