View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

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!