# SVN changeset patch # User LabVIEW # Date 2025-11-17 10:59:59.635343 # Revision 35 - HF limts test: limits optimized =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/PositioningSystem.vi =================================================================== diff --git a/PositioningSystem [LV2021]/PositioningSystem.vi b/PositioningSystem [LV2021]/PositioningSystem.vi --- a/PositioningSystem [LV2021]/PositioningSystem.vi (revision 34) +++ b/PositioningSystem [LV2021]/PositioningSystem.vi (revision 35) Index: PositioningSystem [LV2021]/class_EHF1/class_EHF1.lvclass =================================================================== diff --git a/PositioningSystem [LV2021]/class_EHF1/class_EHF1.lvclass b/PositioningSystem [LV2021]/class_EHF1/class_EHF1.lvclass --- a/PositioningSystem [LV2021]/class_EHF1/class_EHF1.lvclass (revision 34) +++ b/PositioningSystem [LV2021]/class_EHF1/class_EHF1.lvclass (revision 35) @@ -440,7 +440,7 @@ false 1 1 - 1074274832 + 1082139152 =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureDC.vi =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureDC.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureDC.vi --- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureDC.vi (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureDC.vi (revision 35) =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureNetworkAnalyser.vi =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureNetworkAnalyser.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureNetworkAnalyser.vi --- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureNetworkAnalyser.vi (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_MeasureNetworkAnalyser.vi (revision 35) =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_ResistanceForceDistance.vi =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_ResistanceForceDistance.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_ResistanceForceDistance.vi --- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_ResistanceForceDistance.vi (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_ResistanceForceDistance.vi (revision 35) =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_VisualizeHFMeasurement.vi =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_VisualizeHFMeasurement.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_VisualizeHFMeasurement.vi --- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_VisualizeHFMeasurement.vi (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Dialog_VisualizeHFMeasurement.vi (revision 35) =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/NetworkAnalyser_GetData.vi =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/NetworkAnalyser_GetData.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/NetworkAnalyser_GetData.vi --- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/NetworkAnalyser_GetData.vi (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/NetworkAnalyser_GetData.vi (revision 35) =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Test.vi =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Test.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Test.vi --- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Test.vi (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/Test.vi (revision 35) =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization.vi =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization.vi --- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization.vi (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization.vi (revision 35) =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Init.vi =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Init.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Init.vi --- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Init.vi (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Init.vi (revision 35) =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Limits.vi =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Limits.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Limits.vi --- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Limits.vi (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/TestRun_HFVisualization_Limits.vi (revision 35) =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/WriteHFToExcel.vi =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/WriteHFToExcel.vi b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/WriteHFToExcel.vi --- a/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/WriteHFToExcel.vi (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/SubVIs/WriteHFToExcel.vi (revision 35) Index: PositioningSystem [LV2021]/class_PositioningSystem/class_PositioningSystem.lvclass =================================================================== diff --git a/PositioningSystem [LV2021]/class_PositioningSystem/class_PositioningSystem.lvclass b/PositioningSystem [LV2021]/class_PositioningSystem/class_PositioningSystem.lvclass --- a/PositioningSystem [LV2021]/class_PositioningSystem/class_PositioningSystem.lvclass (revision 34) +++ b/PositioningSystem [LV2021]/class_PositioningSystem/class_PositioningSystem.lvclass (revision 35) @@ -1009,7 +1009,7 @@ true 1 1 - 1342972432 + 1342710291 )1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!%.!!!!#!!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!&"!=!!?!!!B(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-!*7.I;7RE9WRB=X.@5'^T;82J<WZJ<G>6<GFU,GRW9WRB=X-A37Y!)%"1!!-!!!!"!!)4:8*S<X)A;7YA+'ZP)'6S=G^S+1"5!0!!$!!$!!1!"!!%!!1!"!!%!!5!"A!%!!1!"!-!!(A!!!U)!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!3!!!!#A!!!!!!!!!!!!!!!!!!!!!"!!=!!!!! @@ -1413,7 +1413,7 @@ true 1 1 - 1115685394 + 1115685392 )1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!$R!!!!#!!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!$2!=!!?!!!B(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-!#%.M98.T)%FO!!!A1&!!!Q!!!!%!!B.F=H*P=C"J<C!I<G]A:8*S<X)J!&1!]!!-!!-!"!!%!!1!"!!%!!1!"1!'!!1!"!!%!Q!!?!!!$1A!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!"!!!!!+!!!!!!!!!!!!!!!!!!!!!!%!"Q!!!!! @@ -1422,7 +1422,7 @@ true 1 1 - 1082139154 + 1082139152 )1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!'\!!!!$A!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!!N!#A!&18BJ=T%!#U!+!!6"?'FT-A!,1!I!"5&Y;8-T!&A!]1!!!!!!!!!#(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-.9V"P=WFU;7^O,G.U<!!C1&!!!Q!&!!9!"R"D1X6S=G6O>&"P=WFU;7^O!!!11#%+47&O>7&M47^E:1!!.%"Q!"Y!!#%@9WRB=X.@5'^T;82J<WZJ<G>4?8.U:7UO<(:D<'&T=Q!*1WRB=X-A4X6U!$2!=!!?!!!B(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-!#%.M98.T)%FO!!!A1&!!!Q!!!!%!!B.F=H*P=C"J<C!I<G]A:8*S<X)J!'%!]!!-!!-!"!!)!!E!"!!+!!1!#Q!-!!1!"!!%!Q!!?!!!$1A!!!!!!!!*!!!!#1!!!!!!!!!."Q!!!!!!!")!!!!+!!!!!!!!!!!!!!!!!!!.!!!!!!!)!!!!!!!!!!!"!!U!!!!! @@ -1431,7 +1431,7 @@ true 1 1 - 1115685394 + 1115685392 )1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!%S!!!!#1!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!$2!=!!?!!!B(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-!#5.M98.T)%^V>!!U1(!!(A!!)2^D<'&T=V^1<X.J>'FP<GFO:V.Z=X2F<3ZM>G.M98.T!!B$<'&T=S"*<A!!)%"1!!-!!!!"!!)4:8*S<X)A;7YA+'ZP)'6S=G^S+1"B!0!!$!!$!!1!"!!%!!1!"1!%!!9!"Q!%!!1!"!-!!(A!!!U)!!!!!!!!!!!!!!!!!!!!!!!!$1=!!!!!!!!3!!!!#A!!!!!!!!!!!!!!!!!!$1!!!!!!#!!!!!!!!!!!!1!)!!!!!! @@ -1449,7 +1449,7 @@ true 1 1 - 1115685394 + 1115685392 @@ -1479,7 +1479,7 @@ true 1 1 - 1115685394 + 1115685392 )1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!%8!!!!#1!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!#"!5!!$!!!!!1!#%W6S=G^S)'FO)#BO<S"F=H*P=CE!#U!(!!25;7VF!!"0!0%!!!!!!!!!!B^D<'&T=V^1<X.J>'FP<GFO:V.Z=X2F<3ZM>G.M98.T$G.4>'6Q2'6M98EO9X2M!"B!5!!"!!9+9V.U:8"%:7RB?1!!6!$Q!!Q!!Q!%!!1!"!!%!!1!"!!%!!5!"!!%!!=$!!"Y!!!.#!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!I!!!!!!!!!!!!!!"!!!!!!!1!)!!!!!! @@ -1497,7 +1497,7 @@ true 1 1 - 1115685394 + 1115685392 )1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!4]!!!!-1!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!&E!S`````QVB=("F<G2F:#"Q982I!!Q!1!!"`````Q!%!!A!5!!"!!5!%E"!!!(`````!!9&2GFM:8-!%U!$!!V-<W&E1XFD<'5A4X6U!">!!Q!1476B=X6S:7VF<H2T)%^V>!!!"1!+!!!51(!!#!!"!!I!%A!!"5&Y;8-T!":!1!!"`````Q!,#%&Y:8.3:7:T!!!U1(!!(A!!)2^D<'&T=V^1<X.J>'FP<GFO:V.Z=X2F<3ZM>G.M98.T!!F$<'&T=S"0>81!$E!S`````Q21982I!!!U1(!!(A!!)2^D<'&T=V^1<X.J>'FP<GFO:V.Z=X2F<3ZM>G.M98.T!!B$<'&T=S"*<A!!)%"1!!-!!!!"!!)4:8*S<X)A;7YA+'ZP)'6S=G^S+1!/1$$`````"&6T:8)!!""!-0````]'6'6T>%F%!!!21!-!#F2F=X2/>7VC:8)!!""!-0````](1W^N<76O>!!21!9!#E:P=G.F4'FN;81!!">!#A!22G^S9W6-;7VJ>&:P<(2B:W5!$U!+!!B7:7RP9WFU?1!!%U!+!!R"9W.F<'6S982J<WY!!!N!#A!%3G6S;Q!!%5!+!!J*<GFU8U&Y;8-R!!!21!I!#EFO;82@18BJ=T)!!"&!#A!+37ZJ>&^"?'FT-Q!!'%!Q`````QZ5:8.U5H6O1W^N<76O>!!!9!$R!!!!!!!!!!)@9WRB=X.@5'^T;82J<WZJ<G>4?8.U:7UO<(:D<'&T=QFD6'6T>#ZD>'Q!,E"1!!U!%1!3!"-!&!!6!"9!&Q!9!"E!'A!<!"Q!(1FD6'6T>%2B>'%!%U!$!!R.:7&T>8*F<76O>(-!!"&!!Q!+4'^B:%.Z9WRF)!!!#U!$!!6*<G2F?!!31%!!!@````]!"!6';7RF=Q!)!&!!!1!C!"*!1!!"`````Q!D"5:J<'6T!":!5!!%!"]!)!!B!#1(2'&U93"*<A">!0%!!!!!!!!!!B^D<'&T=V^1<X.J>'FP<GFO:V.Z=X2F<3ZM>G.M98.T&'..<X:J<G>198*B<76U:8)O9X2M!#"!5!!$!"=!'!!:$UVP>GFO:V"B=G&N:82F=A!71#%2476B=X6S:6*F=WFT>'&O9W5!&U!'!"&3:8.J=X2B<G.F1WBB<GZF<!!31#%-476B=X6S:5:P=G.F!!!91%!!!P``````````!!I'47&U=GFY!!!)!$$`````!#*!1!!#``````````]!+R".982S;8B(:7ZF=G&U;7^O!!!<1!9!&%VB>(*J?%>F<G6S982J<WZ5?8"F!!!81!9!%%RP972$;'&O:W60=(2J<WY!!'M!]1!!!!!!!!!#(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-59V.U:8".:7&T>8*F<76O>#ZD>'Q!,E"1!!E!*A!H!#A!+1!K!"1!,!!N!#Y19V.U:8".:7&T>8*F<76O>!!!91$Q!!Q!!Q!(!!A!#1!-!!U!$A!0!"!!(A!F!#]$!!"Y!!!.#!!!#1!!!!E!!!!*!!!#%!!!!!U(!!!1!!!!%A!!!!I!!!!1!!!!%!!!!"!!!!U!!!!!!!A!!!!!!!!!!!%!-!!!!!! @@ -1605,7 +1605,7 @@ true 1 1 - 1115685394 + 1115685392 )1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!%(!!!!#1!%!!!!%%!B#V.F>&"P=WFU;7^O!".!#A!-5'^T;82J<WYA4X6U!!!+1#%%37ZJ>!!!#5!+!!..98A!$U!+!!F%:8:J982J<WY!51$R!!!!!!!!!!)@9WRB=X.@5'^T;82J<WZJ<G>4?8.U:7UO<(:D<'&T=R&F2'FT>(*J9H6U;7^O,G.U<!!81!9!$%2J=X2S;7*V>'FP<A!!%5!+!!N1<X.J>'FP<C"*<A"5!0!!$!!!!!!!!1!#!!!!!!!!!!-!"!!&!!9!"Q-!!(A!!!!!!!!!!!!!#1!!!!E!!!!!!!!!!!!!!!!!!!!1!!!!%!!!!!A!!!!1!!!!%!!!!!!"!!A!!!!! @@ -1669,7 +1669,7 @@ true 1 1 - 1115685394 + 1115685392 )1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!)@!!!!$Q!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!!N!#A!&18BJ=T%!#U!+!!6"?'FT-A!,1!I!"5&Y;8-T!&!!]1!!!!!!!!!#(W.M98.T8V"P=WFU;7^O;7ZH5XFT>'6N,GRW9WRB=X-.9V"P=WFU;7^O,G.U<!!;1&!!!Q!&!!9!"QB1<X.J>'FP<A!!)%"1!!-!!!!"!!)4:8*S<X)A;7YA+'ZP)'6S=G^S+1!-1#%'23V4>'^Q!!!&!!I!!"J!1!!#``````````]!#QF*<H.F>%2B>'%!RA$R!!!!!!!!!!)@9WRB=X.@5'^T;82J<WZJ<G>4?8.U:7UO<(:D<'&T=RJF4'6B=GZJ<G>#>82U<WZT4X"U;7^O,G.U<!#$1"9!#!J%;8.B9GRF17RM$52J=W&C<'6.<X:J<G='27ZB9GRF$5.I:7.L5G6M982J>G5-5WBP>V*F<'&U;8:F$%BJ:'63:7RB>'FW:1N4;'^X476B=X6S:1N);72F476B=X6S:1!7:5RF98*O;7ZH1H6U>'^O=U^Q>'FP<A!!6!$Q!!Q!!Q!%!!1!"!!%!!1!"!!)!!E!#A!-!!U$!!"Y!!!.#!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!#!!!!!I!!!!+!!!##!!!!"!!!!!!!1!/!!!!!! @@ -1912,7 +1912,7 @@ true 1 1 - 1115685394 + 1115685392 )1#!!!!!!!)!"1!&!!!-!%!!!@````]!!!!"!!%!!!%H!!!!$Q!-1#%'=X2B>(6T!!!,1!-!"'.P:'5!!""!-0````]'=W^V=G.F!!!71&!!!Q!!!!%!!AFF=H*P=C"P>81!"!!!!""!-0````]'5X2S;7ZH!!!31%!!!@````]!"16/97VF=Q!A1&!!!Q!!!!%!!B.F=H*P=C"J<C!I<G]A:8*S<X)J!"*!-P````])6'6N='RB>'5!!!>!#A!"7!!(1!I!!6E!#A"1!!)!#1!+!""!1!!"`````Q!,!FB:!!!/1$,`````"&"B>'A!!&1!]!!-!!-!"!!%!!1!"!!%!!9!"!!(!!A!$!!.!Q!!?!!!$1A!!!!!!!!!!!!!!!!!!!!!!!!!!!!#%!!!!!!!!!!+!!!!%!!!!B!!!!!1!!!!!!%!$A!!!!! =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: builds/PositioningSystem.exe =================================================================== diff --git a/builds/PositioningSystem.exe b/builds/PositioningSystem.exe --- a/builds/PositioningSystem.exe (revision 34) +++ b/builds/PositioningSystem.exe (revision 35) Index: support/ReportTemplates/Macro.bas =================================================================== diff --git a/support/ReportTemplates/Macro.bas b/support/ReportTemplates/Macro.bas --- a/support/ReportTemplates/Macro.bas (revision 34) +++ b/support/ReportTemplates/Macro.bas (revision 35) @@ -453,7 +453,6 @@ ' 7) Diagramme für die HF-Messung ' ========================================= Sub AktualisiereXYDiagrammHF() - Dim datenWs As Worksheet Dim diagrammWs As Worksheet Dim chartObj As ChartObject @@ -470,25 +469,25 @@ Application.ScreenUpdating = False Application.EnableEvents = False - ' Für Paare 2->18, 3->19...17->33 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 + ' Für Paare 2->18, 3->19...17->33 For dataIndex = 2 To 17 - + chartIndex = dataIndex + 16 - + Set datenWs = ThisWorkbook.Worksheets(dataIndex) Set diagrammWs = ThisWorkbook.Worksheets(chartIndex) Set chartObj = diagrammWs.ChartObjects(1) Set diagramm = chartObj.Chart - + letzteZeile = datenWs.Cells(datenWs.Rows.Count, 1).End(xlUp).Row letzteSpalte = datenWs.Cells(2, datenWs.Columns.Count).End(xlToLeft).Column - + Set xRange = datenWs.Range(datenWs.Cells(3, 1), datenWs.Cells(letzteZeile, 1)) - + Do While diagramm.SeriesCollection.Count > 0 diagramm.SeriesCollection(1).Delete Loop - + For i = 2 To letzteSpalte Set yRange = datenWs.Range(datenWs.Cells(3, i), datenWs.Cells(letzteZeile, i)) With diagramm.SeriesCollection.NewSeries @@ -497,21 +496,33 @@ .Values = yRange .Smooth = False .ChartType = xlXYScatterLines - + ' --- Nur Linie, keine Punkte --- .MarkerStyle = xlMarkerStyleNone End With Next i - + ' ---- Farben der ersten 3 Serien fest zuweisen ---- If diagramm.SeriesCollection.Count >= 1 Then diagramm.SeriesCollection(1).Format.Line.ForeColor.RGB = RGB(255, 128, 64) If diagramm.SeriesCollection.Count >= 2 Then diagramm.SeriesCollection(2).Format.Line.ForeColor.RGB = RGB(255, 0, 0) If diagramm.SeriesCollection.Count >= 3 Then diagramm.SeriesCollection(3).Format.Line.ForeColor.RGB = RGB(0, 128, 189) + ' ---- Legende nur ausblenden, wenn: + ' Datensatz 1 leer, Datensatz 2 leer, Datensatz 3 hat Werte ---- + Dim hat1 As Boolean, hat2 As Boolean, hat3 As Boolean + + hat1 = WorksheetFunction.CountA(datenWs.Range(datenWs.Cells(3, 2), datenWs.Cells(letzteZeile, 2))) > 0 ' Spalte B + hat2 = WorksheetFunction.CountA(datenWs.Range(datenWs.Cells(3, 3), datenWs.Cells(letzteZeile, 3))) > 0 ' Spalte C + hat3 = WorksheetFunction.CountA(datenWs.Range(datenWs.Cells(3, 4), datenWs.Cells(letzteZeile, 4))) > 0 ' Spalte D + + If (Not hat1) And (Not hat2) And hat3 Then + diagramm.HasLegend = False + Else + diagramm.HasLegend = True + End If + Next dataIndex Application.EnableEvents = True Application.ScreenUpdating = True - -End Sub - +End Sub \ No newline at end of file