Line bars on SPC charts
I am trying to create a chart with top and bottom controls. I was trying to achieve a similar look in the first image where the top and bottom controls are a box and not my effort, image 2 where I just made a thick line.
I have seen several ways how to do this and have applied them with some degree of success, but the main problem I am having is to look as you look at my second image, you will see the top and bottom controls wobble. All the examples I've seen just show stripes of lines as straight lines. Is there a way to do this?
For my lower control, I tried to type = Fields! LowerControl.value
but it still only gives a straight line
source to share
EDIT . Go with Pete below. I am struggling to plot the top control using a range chart. Can anyone point me to where I am going wrong?
I don't know how to dynamically split a StripLine. However, if you have data about what controls should be in each date, you can plot them on the chart like any other data.
Include controls along with each value of your SQL dataset, for example:
SELECT
a_date, a_value,
CASE WHEN a_date <= '01-MAR-2017' THEN 25 ELSE 30 END lower_control,
CASE WHEN a_date <= '01-MAR-2017' THEN 50 ELSE 55 END mid_control,
CASE WHEN a_date <= '01-MAR-2017' THEN 75 ELSE 80 END upper_control
FROM
a_table
If a simple string is enough for your controls, you can add each control to the values ββas a series of charts with appropriate formatting.
If you want your controls to cover a large area, you can plot this with a range chart.
Change: . For the high range range, you need to set the values ββto "Top" and "Bottom". The bottom value is from your data uppercontrol
, and the top value is the maximum value on your Y-axis. (For example, in the above chart, I set both the maximum Y-axis and the top uppercontrol
to 100.)
Also know the order of your ranges. Either enter the data string first so that it appears above each control, or give your controls a color with some transparency.
source to share