Change y-axis to category in a column chart

[Ben Hill]

I am making charts for data that we took at the school where I
teach. We polled seven grades in six different strands of questions.
Their replies were 'Always', 'Frequently', 'Occasionally', and
'Never'. We translated these into 4, 3, 2, & 1 to get averages. I
have a chart that shows the 42 averages as columns grouped by grades
and a chart that shows the 42 averages grouped by strand. I'd like
my column chart y-axis to show the words instead of 4, 3, 2, 1.

I have read a little about dummy series and I don't understand it
yet, but it seems to apply to an X-Y scatter rather than to my
situation. Is my wish a possibility?

I'm using 2003 and XP Professional.

Thank You.

 

[Del Cotter]

I'd like my column chart y-axis to show the words instead of 4, 3, 2, 1

I have read a little about dummy series and I don't understand it
yet, but it seems to apply to an X-Y scatter rather than to my
situation. Is my wish a possibility?

That's okay, because "chart type" isn't something you're forced to have
all the same. It can be different for every series. You simply add that
dummy series (which will look like another column series at first, but
don't worry!) and then change it to an XY series.

 

[Tushar Mehta]

I am making charts for data that we took at the school where I
teach. We polled seven grades in six different strands of questions.
Their replies were 'Always', 'Frequently', 'Occasionally', and
'Never'. We translated these into 4, 3, 2, & 1 to get averages. I
have a chart that shows the 42 averages as columns grouped by grades
and a chart that shows the 42 averages grouped by strand. I'd like
my column chart y-axis to show the words instead of 4, 3, 2, 1.

I have read a little about dummy series and I don't understand it
yet, but it seems to apply to an X-Y scatter rather than to my
situation. Is my wish a possibility?

I'm using 2003 and XP Professional.

Thank You.

Jon Peltier has an example on his web site that you should be able to
adapt to your use. I don't have a direct link to the page but search
www.peltiertech.com

 

[Ben Hill]

That's okay, because "chart type" isn't something you're forced to
have all the same. It can be different for every series. You simply
add that dummy series (which will look like another column series at
first, but don't worry!) and then change it to an XY series.

Thanks. It did work. I don't know how yet, but I works. I'll keep
playing with it.