3 parameters chart in ms access

[jj1]

I want to make a chart which will show up Problem, number of problems and different solutions used in each problem. How can I do that. So Y axis shows problems and its count and problem bar graph will show different divisions for solution

[June7]

Are you able to generate the graph in Excel? If you can do it in Excel, might be able to replicate in Access (no guarantee).

Show image of desired graph output and provide sample data. I analyse graph issues best when I can work with data. If you want to provide db for analysis, follow instructions at bottom of my post.

[jj1]

Attached is the graph I want to make in Access or spitting data from Access to Excel in form of chart. I need help desperately

[June7]

That graph type is possible in Access. Really need to know the structure of your raw data. Possibly all you need is a pivot (CROSSTAB) query as the RowSource of graph object.

Or you can try a PivotTable or PivotChart View of table or form.

However, need to switch the data so the RootCauses are column headers and Training/VSOP/SOP are values of some field named maybe Category.

Category	Knowledge	Procedure	Process
Training	5	2	1
VSOP	4	3	4
SOP	2	8	5

If the above output is a table or query object, then the RowSource for graph would be (or do CROSSTAB directly in the RowSource):

SELECT Category, Knowledge, Procedure, Process FROM tablename;

Category will be the X-axis and values of the other fields will stack in the bars.

The graph wizard will not present the stacked bar as an option. Have to create a graph - any graph, any data - then edit its properties. Manual edit of graph properties will offer stacked bar option then change the RowSource.