Change y-axis to category in a column chart

  • Thread starter Thread starter Ben Hill
  • Start date Start date
B

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.
 
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?
Click to expand...

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.
 
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.
Click to expand...
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
 
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.
Click to expand...

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