Assistance required with “Dual Axis Chart Formatting” of my “Target Chart”

Hi All,

I would appreciate any assistance with regards how to go about configuring the “Dual Axis” of my workbook Target Chart.

Logic:

• I have five types of measures to be charted, namely

1.       Bushels

2.       Target

3.       LCL (Lower Control Limit)

4.       UCL (Upper Control Limit)

5.       Mean

Required:

• My chart has to be configured as follows

1.       Bushels – Needs to be a “Bar Chart”, and on the Primary axis

2.       Target – Needs to be a “Line Chart” and on the secondary axis with “No data labels”

3.       LCL (Lower Control Limit) – Needs to be a “Circle Chart” and on the secondary axis

4.       UCL (Upper Control Limit) – Needs to be a “Circle Chart” and on the secondary axis

5.       Mean – Needs to be a “Circle Chart” and on the secondary axis

• Current Chart status regarding my attached workbook, I need guidance with:

1.       Bushels – All good on this one

2.       Target – I can’t seem to configure the line chart and ignore the data labels, the chart is tied to the bubble chart formatting

3.       LCL (Lower Control Limit) – All good on this one

4.       UCL (Upper Control Limit) – All good on this one

5.       Mean – All good on this one

Note!

My workbook is attached

Any guidance will be appreciated,

Cheers,

Lance