Adding secondary axis to stacked % chart?

[emgee]

Dear xcellers,

I have a stacked chart with data on open/closed items per week;
the x-axis has the weeks and on the Y-axis we have % open/closed items:
I wnow wish to have on Yaxis on the right side of the chart (secondary axis)
the total number of items in that week (= # open + # closed);
Is there an easy way to achieve this?

Thank you

 

[Andrew Poulsom]

Could you post a small sample of the data you are plotting, either using Colo's utility (below) or in tabular form within the body of the message?

 

[emgee]

Dear Andrew,

a small part of my data set

wkday closed_% open_% # closed # open
319.1 48.1 51.9 88 95
319.2 48.1 51.9 88 95
319.3 48.1 51.9 88 95
319.4 51.4 48.6 94 89
319.5 51.4 48.6 94 89
320.1 51.4 48.6 94 89
320.2 51.9 48.1 95 88
320.3 51.9 48.1 95 88
320.4 51.9 48.1 95 88
320.5 51.9 48.1 95 88
321.1 51.9 48.1 95 88

THis is the dataset (the Colo utility did not work ( a library or project missing
no idea about that)

Hope this will help

 

[Andrew Poulsom]

Right click the chart and choose Source Data. On the Series tab click Add and in the Values box specify the range for # Closed. Repeat for # Open and click OK. Right click the # Close series, choose Chart Type, click Line and OK. Repeat for the # Open series. Right click the # Close series, choose Format Data Series, check Secondary axis on the Axis tab and click OK. Repeat for the # Open series.