How to create a graph displaying categories on X as well as on Y axis?

**Juttko** · 10-28-2010, 03:19 PM

I'm trying to create a graph displaying 3 x 2 categories of data, and one of the 3 categories should be on the y axis. But I can only seem to create multiline category labels that show up on the x axis, rather than having one of my categories be displayed on the y axis. My goal is to avoid having 6 related data points displayed against a category on the x axis. My data: I have 16 questions, and data points for 3 sub-categories per question. I want to display the mean values for each question's sub-category, alongside each respondent's actual rating. Each data point per sub-category was measured on the same scale, i.e. 1-5.
Has anyone done something like this, and how? Thanks for any help you can provide...

**shg** · 10-28-2010, 03:24 PM

Welcome to the forum.

See if http://peltiertech.com/Excel/Charts/axes.html helps.

These are Likert-scale responses?

**Juttko** · 10-28-2010, 03:49 PM

Hi, thank you for this! I'm checking out the link you added, but believe that my problem is that my Questions along the X axis are not linked - hence anything like a line graph doesn't apply here. I'm attaching the (very difficult to read) Excel graph I did create, alongside a hand-drawn image of what I'm trying to achieve..

Thanks again!