Create a Pivot/Bar Chart (Pareto Chart) in Access

[dccjr]

I am trying to create a pivot chart based on an SQL query that is based on two comboboxes. So far everything I can find on the web creates these charts in Excel. I would like to create the chart in a user form view that will allow the user to opt to print the chart. I am not sure whether it would be better to open the chart in print preview, or to open it on a blank user form, and allow the user to print via a command button and have it carry this out in the background. I hope that this all makes sense to someone. So I guess my questions are:



1) Do I have to create the chart using Excel through VBA?
2) If not, how would I carry this out in Access VBA?
3) What is the most efficient way to allow the user to view and or print the chart?

I would appreciate any guidance/assistance that someone could provide in this quest.

[June7]

1. graphing is easier in Excel than Access but most graphing can be replicated in Access

2. Google: Access pareto chart

Start with http://support.microsoft.com/kb/304180

Also, selection of Custom Types in the chart control includes Line-Column.

3. Maybe build a report with graph control

[dccjr]

I'm not sure how to apply the information in the link above, given that the data for the Pareto chart will vary depending on the selections made in two combo boxes. Does anyone know if this can be done in VBA? I have tried looking online, but it all seems to involve Excel.

[June7]

The selections in comboboxes are to filter the records?

[dccjr]

Yes. Paretos are ran by either: date-to-present, Work Area/Cell, Defect Category, or Defect Type. With date-to-present, the user can select the start date.

[June7]

So this is related to thread https://www.accessforums.net/queries...lds-31601.html ?

[dccjr]

Similar. It the previous thread, I was populating a combo box based on another combo box. I think that I understand the query portion, I am not sure how to assign the query results to a pivot chart via vba. I tried to find examples online, but could find anything that fit anything close to my needs. I also need to be able to print the pivot chart.

[June7]

Are you doing a PivotChart view of a table or form or are you doing a chart object on form?

[dccjr]

I am completely clueless as to what the difference is. Is one inherently better for my purpose? I have never tried to create a chart in Access. Suggestions? I do the research, but don't even know where to start.

[June7]

I have never used pivot chart view of tables or forms. Be aware, Microsoft has removed Pivot Table/Chart views from Access 2013.

The Pivot Table/Chart views have some built-in capability for dynamic filtering but very limited formatting and AFAIK, cannot be referenced in VBA code. A chart is a control selected from the set of controls on ribbon and can be formatted and manipulated with VBA code.

Seems I once built a Pareto type chart with chart control to help a poster but never used one myself.

Start with Access Help and here is a nice introductory article http://vb123.com.au/toolbox/09_acces...07charting.htm