CSi Chart

[D Willett]

Hi

I've tried several times to create a chart with a query:

SELECT tblEST.Est, tblEST.Sup, tblEST.Client, tblEST.STA, tblEST.Finished, tblCSi.Politeness, tblCSi.Quality, tblCSi.Overall, tblCSi.TimeTaken, tblCSi.Problem, tblCSi.UseAgain, tblCSi.ReInsure, tblCSi.NPS, tblCSi.Comment
FROM tblCSi INNER JOIN tblEST ON tblCSi.Est = tblEST.Est
WHERE (((tblEST.STA)="F"));

The categories from the table ( Legend ) are: "Complety Satisfied", Fairly Satisfied", "Dissatisfied", "Yes", "No"

I just can't get the chart as the attached PNG.
Any help is appreciated. ( The PNG is a scan of the chart from an XLS file )

[HansV]

Hi Dave,

- What is the field containing the x-axis categories ("Politeness staff" etc.)?
- What is the field containing the series names ("Completely satisfied" etc.)?
- What do the y-axis values represent? The number of records?

[D Willett]

Hi Hans

See attached png of the table and results...

[HansV]

Hi Dave,

That's a rather nasty one since you have two types of fields with completely distinct values: Politeness ... Completed with values "Completely satisfied" etc., and Problem ... Renew with values True/False.
Could you attach a small sample database (compacted and zipped) so that we can try out things?

[D Willett]

Hi Hans

Please see attached, Hope this helps. ( Please ignore the NPS field at the end in tblCSi, Sorry)

Thanks

[HansV]

Sorry, was away for some time. To do what you want takes a series of crosstab queries that is combined using a union query.
See the attached version.

Chart.zip

x94.png

[D Willett]

Cheers Hans

I'll have a look at it later, looking at the image you have worked a miracle once more. :-)
Have a great day & thanks.