How to insert an easy to read chart for multiple Axis?

[ejwjohn]

Hello,

I have a Yacht Club survey in place which is being summarized in an excel sheet as indicated in the attached image.

There are 6 questions similar to that in A6, with the answer specific to 2 types of boat as in B/C6 and D/E6
Each question has 3 possible answers as in A7,8 & 9, with the answers in the corresponding B/C and D/E cell pair which represent the same value but in different formats. ( numeral and %)

The challenge for me is how do I get one chart that represents the A6 to D9 cells? as indicated earlier I have 5 other questions on this sheet so I was hoping to get the 6 charts along with the data on the same sheet and still make the charts understandable?

Thanks in advance of your help.
JohnW

 

[ejwjohn]

Thanks to all for your support,

Here is my chart-

It's a little bright !!!, but it works

Thank You very much

JohnW

 

[ejwjohn]

Hello,

I thought i had submitted this earlier but it seems to have "Gone Missing"

My finished chart is below:-

A little bright, I know but it works.....

Once again thanks for all your excellent advice

JohnW

 

[ejwjohn]

Not sure what is happening now there are duplicate responses.

Apologies.

JohnW

 

[ejwjohn]

Ok Sorted, I did not notice that the thread had expanded to a 2nd page.

JohnW

 

[GraH]

Thanks to all for your support,

Here is my chart-
View attachment 14142

It's a little bright !!!, but it works

Thank You very much

JohnW

You made it, that's great. Glad I could help.
FYI, a combo of red and green is perhaps not the best of choices as 10% of People won't distinguish those colors. Personally I would give it some air between the questions or clusters.

 

[ejwjohn]

Yes Ok, take your point thanks

JohnW