6 Replies Latest reply on Jun 30, 2016 3:54 PM by Lance Martens

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

    Lance Martens

      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