Charting survey results (Descriptions as value labels)

I conducted a survey allowing people to rank 8 different items as Not
Important, Important, Very Important, or Critical. I want to create a column
chart from this.

To create the column chart, I used a combination of INDEX and MATCH to
assign each answer a numeric value (0 for Not Important, 1 for Important,
etc.), and I then used a pivot table to find the averages. Easy enough;
worked fine. I can now put the data in a column chart, and easily see what
people view as important or not important.

For the sake of my audience, I need to somehow take my value axis labels
(which of course appear as 0, 1, 2, and 3) and label them with the
descriptive text (Not Important, Important, etc.) instead of numbers. I
prefer being able to re-label those value axis labels, but at this point I'd
even be satisfied with a legend that would accomplish the same thing.

Any ideas?

Hi,

For a normal chart, that is not a pivot chart, you can use a dummy series to
display the labels.
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"bnick22" <bnick22.TakeThisOut@discussions.microsoft.com> wrote in message
news:2E69922F-8B7F-4E2C-946E-AE771597AC28@microsoft.com...
>I conducted a survey allowing people to rank 8 different items as Not
> Important, Important, Very Important, or Critical. I want to create a
> column
> chart from this.
>
> To create the column chart, I used a combination of INDEX and MATCH to
> assign each answer a numeric value (0 for Not Important, 1 for Important,
> etc.), and I then used a pivot table to find the averages. Easy enough;
> worked fine. I can now put the data in a column chart, and easily see what
> people view as important or not important.
>
> For the sake of my audience, I need to somehow take my value axis labels
> (which of course appear as 0, 1, 2, and 3) and label them with the
> descriptive text (Not Important, Important, etc.) instead of numbers. I
> prefer being able to re-label those value axis labels, but at this point
> I'd
> even be satisfied with a legend that would accomplish the same thing.
>
> Any ideas?