Adding second y-axis to OLAP pivot chart

[Priscilla Uribe]

I would like to have a chart with the following:
X-axis: Week of
Y-axis: Lines of Code(LOC)
Second Y-axis: # of Defects

When I try to add the second axis, the option is disabled. How do I
create the chart using a pivot table to have two different series, in
order to create a second axis, I believe this is the main problem.
When I select the column for a second axis it selects all data. What
am I doing wrong here?

Which type of chart should I use? Right now it's a stacked column
chart, but the columns are side by side and I want them as one column
with two colors, then two axis. Is this possible with a pivot table
using an OLAP data resource?

Thanks for all the help, I have been messing with this for days now!!!
grr.

~Priscilla Uribe
(e-mail address removed)