<span style="font-size:small;">I have a small database (around 60 records) of data responses that I need transformed into Pivot tables, and then spider/star charts, XY scatter charts, etc. A one-off job at moment, but need it done fairly quickly. Once the pivots are done, then the below charts can be done for the following:<br /><br />b. Importance-Satisfaction cross-plots for each attribute (all companies)<br /><br />c. Importance-Satisfaction cross-plots for each attribute group (=the average of all attributes in a particular epigraph) (all companies)&nbsp;<br /><br />d. Importance-Satisfaction cross-plots for each company (all attributes)<br /><br />e. Importance-Satisfaction cross-plots for each company (all attribute groups)<br /><br />f. Star-Chart for each company: management vs. operations (two polygons in the same chart, one chart per company), for all the attributes that will be asked to both groups<br /><br />g. Star-Chart for each company: management vs. operations (two polygons in the same chart, one chart per company), for all the attribute groups that will be asked to both groups<br /><br />h. Star-Chart: importance for each company (one polygon line each company) of all the attributes (one axis each)<br /><br />i. Star-Chart: importance for each company (one polygon line each company) of all the attribute groups (one axis each)<br /><br />j. Star-Chart: satisfaction for each company (one polygon line each company) with all the attributes (one composite axis each: same number of axes as for the importance, method of aggregation: average of both M &amp; O responses)<br /><br />k. Star-Chart: satisfaction for each company (one polygon line each company) with all the attribute groups (one composite axis each: same number of axes as for the importance)<br /><br />l. Bar-Chart: average (M,O) importance per attribute (all companies)<br /><br />m. Bar-Chart: average (M,O) importance per attribute group (all companies)<br /><br />n. Bar-Chart: average (M,O) satisfaction per attribute (all companies)<br /><br />o. Bar-Chart: average (M,O) satisfaction per attribute group (all companies)<br /><br />p. Importance-Satisfaction General Cross-Plot: for all the attributes (the average of all companies)<br /><br />q. Importance-Satisfaction General Cross-Plot: for all the attribute groups (the average of all companies)<br /><br />r. Bar-Chart: general satisfaction level (weighted by importance) for each company (method of aggregation: please specify)<br /><br />Please respond before 31 July.<br />Thanks<br />Andy<br /></span>