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!