How to plot this????

[Jodi]

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!

 

[bj]

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.