The design of your table is indeed the problem. Your responses should be recorded in a related table with one record for each response and each such "response record" should then be linked to a specific question via the relationship.
Then you could set up your summary field in this response table and use a layout based on that table to chart your responses.
But there may be a way to chart the data from the current table. Do you want a separate chart for each question?
If so, you can probably get this to work with the delimitted data option using this expression to produce the y-series data:
List ( Strongly Agree ; Somewhat Agree ; Somewhat Disagree ; Strongly Disagree ) // if N/A is a response field, include it also.
Thanks. I shall restructure the tables!