Thread: How to plot this????

I have data like this:

Insufficient 1 1 3 4 1 Sufficient
Not Informative 1 2 1 4 2 Informative
Inappropriate 1 2 3 3 1 Appropriate
Incomplete 1 4 1 2 2 Complete
Irrelevant 1 1 3 2 3 Relevant

I want to plot it as a 100% stacked bar chart like this:

Insufficient @~xxx%%%%+ Sufficient
Not Informative @~~x%%%%++ Informative
Inappropriate @~~xxx%%%+ Appropriate
Incomplete @~~~~x%%++ Complete
Irrelevant @~xxx%%+++ Relevant

I can get the chart to plot the data and the left hand vertical axis labels
but not the right hand vertical labels.

Any ideas most appreciated!

put in some dummy data and add to the plot
select the plot section with this data and
<format data series>
change the axis to secondary

then go to <chart><source data> <series>
and add references to the second catagory (X) axis labels section.

Then go to <chart><Chart options><axis>
and select secondary axis catagory (X)
don't forget to set all your dummy data to zero when you are done.

"Jodi" wrote:

> I have data like this:
>
> Insufficient 1 1 3 4 1 Sufficient
> Not Informative 1 2 1 4 2 Informative
> Inappropriate 1 2 3 3 1 Appropriate
> Incomplete 1 4 1 2 2 Complete
> Irrelevant 1 1 3 2 3 Relevant
>
> I want to plot it as a 100% stacked bar chart like this:
>
> Insufficient @~xxx%%%%+ Sufficient
> Not Informative @~~x%%%%++ Informative
> Inappropriate @~~xxx%%%+ Appropriate
> Incomplete @~~~~x%%++ Complete
> Irrelevant @~xxx%%+++ Relevant
>
> I can get the chart to plot the data and the left hand vertical axis labels
> but not the right hand vertical labels.
>
> Any ideas most appreciated!
>
>