Possible to use pivotcharts to analyse data for two series side by side in a chart?

Evening! I have undertaken a survey as part of a study and now need to analyse the the slew of responses I've received. I believe that pivotcharts/pivot tables are the easiest and quickest way to go, but as I'm teaching myself this as I go along I'm really not sure whether what I'm trying to do is possible!

In a nutshell, (the attached gives a visual example), I have a range of respondents i.e. A Plc, B Plc, C Plc. Each falls into a sub-categorization i.e. Small/Medium/Large. I'm looking to have the chart display the responses provided by one respondent i.e. A Plc to a particular question (i.e. Agree/Disagree etc) and also the same responses provided by all respondents residing within sub-categorization they fall within i.e. Small. So far I've found it easy to compare individual respondents within the same chart, but have had no luck comparing two different series within the same chart.

So, in the attached example, I'm looking to have another set of bars representing the responses provided by all respondents within the 'Small' sub-category as well.

Is what I'm looking to do possible with a pivotchart? Any advice or alternatives would be much appreciated - I have about 30 respondents and as many questions, so am looking to automate the process as much as possible.

Thanks!

Originally Posted by Andy Pope

put the organisation in the Page field and select Small.

Hi Andy

Many thanks for your response (and apologies for the lateness of mine), however I'm looking to compare responses by 'company' and 'organisation' within the same chart. I've attached an extremely crude visualisation of what I'm trying to achieve - do you know whether this is this possible via pivotcharts or any other way with the exception of manually creating a chart for each response?

Cheers!Example - revised.xlsx

Originally Posted by Andy Pope

Don't think you can do that with PT.

You would need to use formula to build the chart data. Example attached

Ah well, not to worry. Thanks again for the advice, I shall go down that route!