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.

On Sun, 8 Jul 2007, in microsoft.public.excel.charting,
Ben Hill said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

In article ,
says...
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

Del Cotter wrote in
:

On Sun, 8 Jul 2007, in microsoft.public.excel.charting,
Ben Hill said:
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.


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