I have a column chart of pieces per man hour (PPMH) v/s date by week. I have a target PPMH for the time period. I need to do two things:
1) Plot the target PPMH as a straight line on the chart. (Do I create a separate series for this?)
2) All columns below the target PPMH should be in the color red and all columns above the target PPMH should be black.
How can I do this? Thanks.........
1) Plot the target PPMH as a straight line on the chart. (Do I create a separate series for this?)
2) All columns below the target PPMH should be in the color red and all columns above the target PPMH should be black.
How can I do this? Thanks.........
