Set Point Line
Set Point Line
(OP)
Hello Everyone,
I make a lot of scatter graphs where I compare temperatures to their setpoints using Excel.
I'm wondering if there is a way to mark the set point on the graph as an option? What I've been doing is either drawing a line or adding a set point temperature column in my data. I do not want to add a trendline.
Is there a better way to do this? I've tried Google, but not really sure the best keywords to use. I keep getting sent back to trendlines.
I make a lot of scatter graphs where I compare temperatures to their setpoints using Excel.
I'm wondering if there is a way to mark the set point on the graph as an option? What I've been doing is either drawing a line or adding a set point temperature column in my data. I do not want to add a trendline.
Is there a better way to do this? I've tried Google, but not really sure the best keywords to use. I keep getting sent back to trendlines.





RE: Set Point Line
Prone to error
That’s what I do. Easy and reliable.
=====================================
(2B)+(2B)' ?
RE: Set Point Line
Except all you really need are two points.
RE: Set Point Line
Good point MJ. Just to need to make sure it spans my entire data set.
You would have thought it would be easy to do this, but apparently not.
RE: Set Point Line
The example worksheet http://www.sigmazone.com/Files/SPCXL_Examples.xls uses a full column; unfortunately, the sheets are hidden.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Set Point Line
Essentially it would be the same as adding a setpoint series, just bypassing the need to have a column for the data.
RE: Set Point Line
Cheers.
RE: Set Point Line
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Set Point Line
CODE
Public Function CreateSetLine() Setmax = ActiveChart.Axes(xlValue).MaximumScale Setmin = ActiveChart.Axes(xlValue).MinimumScale SetValue = CDbl(InputBox("Set Point")) ActiveChart.SeriesCollection.NewSeries.Name = "SetPoint" ActiveChart.Axes(xlValue).MaximumScaleIsAuto = False With ActiveChart.SeriesCollection("SetPoint") .XValues = Array(Setmin, Setmax) .Values = Array(SetValue, SetValue) .ApplyDataLabels ShowSeriesName:=True End With End FunctionRE: Set Point Line
hope this helps.
-pmover
RE: Set Point Line
Are you saying just use a column or row with the setpoint value in the data set? If not, can you please explain further?
RE: Set Point Line
Best to you,
Goober Dave
Haven't see the forum policies? Do so now: Forum Policies
RE: Set Point Line
I was trying to avoid adding another column to my data, but that also works.
RE: Set Point Line
a suggestion is to have a cell which is a zero (0 = false) or one (1 = true). the cells with setpoints will need a formula to either display the setpoint value or nothing at all, depending upon the value with a 0 or 1.
another suggestion is to plot a series with only the min & max x-values and have the setpoint as y-values for min/max x-values. this would allow for a single line across the chart.
another suggestion is to place the chart on a chart-sheet (if not there). the switch to the developer tab and insert a check box onto the chart which is linked to the cell with a 0 or 1. while viewing the chart, selecting the check box will display the chart and vice versa. additionally, a scroll bar or spin button can be inserted/overlayed on chart to change the value of setpoint (will need to define the setpoint range (right-click the scroll bar to get the sub menu and select format control).
enough thinking for now . . .
hope this helps and good luck!
-pmover
RE: Set Point Line
Thanks.