Excel Comparison Bar Chart - But to also include a TOTAL column just on the RHside Xaxis

I'm trying to produce a graph with a number of items - but also with a total

I have uploaded a simple example to try an show what I'm after

Lets say I have four areas

............. Target.....JuneActual......JulyActual
BU1...........20.............19.................18
BU2...........10..............6...................8
BU3...........16.............16.................15
BU4...........14..............12................14

Now I can plot that OK as a comparison Bar chart

But on the righthand side of the chart I want to add a 2nd axis shoing the total
Total..........60...........53...................55

each time a try to add a 2nd axis it applies to all the data series
I tried putting a series in that I could hide

None of that worked

SO lefhand sacle would be 0-22 with the first set of figures and for each BU on the X axis
and then the righthand scal with be 0-65 and show a column on the right hand side with the total numbers and total on the X axis

and advice please

Thanks

Thanks, But That rescales all the values for the data element green to use the 2nd Axis

I just want the 3 totals values to use the second axis and not the BU values

i solved it with support and needed to change the data layout to

BU1...........20........0.....19.......0..........18
BU2...........10........0......6.......0...........8
BU3...........16........0.....16.......0..........15
BU4...........14........0......12......0..........14
Total....................60..............53...................55

then change the rows/columns
and then I can apply the 2nd scale to apply to the total data set

solved