Topic: Trendline on Bar Chart (MVD 5.6)
Eureka! I managed to add a trendline to a bar chart (MVD 5.6) with the help of ChatGPT. I searched the forum for a solution, but couldn't find one.
Var
ChartBar: TChart;
procedure Form1_OnShow (Sender: string; Action: string);
begin
// CHARTBAR====================================================================
ChartBar := TChart.Create(Form1);
ChartBar.Parent := Form1.PanelBar;
ChartBar.Align := alClient;
ChartBar.AddSeries(TBarSeries.Create(ChartBar));
TBarSeries(ChartBar.Series[0]).Marks.Visible := False;
ChartBar.Axes.Bottom.LabelsAngle := 90;
ChartBar.View3DOptions.Zoom := 90; // Ajuste o zoom para caber todos os labels
ChartBar.Legend.Visible := true;
Form1.bBarUpdate.Click;
end;
procedure Form1_bBarUpdate_OnClick (Sender: TObject; var Cancel: boolean);
var
Results: TDataSet;
sData: string;
sValue: string;
x: integer;
sumX, sumY, sumXY, sumX2: Double;
n: Integer;
a, b: Double; // Coeficientes da reta Y = aX + b
firstX, lastX: Integer;
begin
ChartBar.Series[0].Clear;
if ChartBar.SeriesCount < 2 then
ChartBar.AddSeries(TLineSeries.Create(ChartBar)); // cria série p/ tendência
ChartBar.Series[1].Clear; // limpa a linha de tendência
TLineSeries(ChartBar.Series[1]).SeriesColor := clRed; // cor da tendência
x := 1;
sumX := 0;
sumY := 0;
sumXY := 0;
sumX2 := 0;
n := 0;
SQLQuery('SELECT strftime("%d/%m/%Y",Data) as DMA, valor FROM tbl_medicoes WHERE'+
' id_tbl_parametros = '+inttostr(form1.cbo_parametro.dbItemID)+' and id_tbl_usuarios = '+inttostr(form1.cbo_user.dbItemID)+
' and Data >= '+form1.dt_ano_mes_ini.sqlDate+' and Data <= '+form1.dt_ano_mes_fim.sqlDate+' and'+
' case when length("'+form1.cbo_sit.text+'") = 0 then 1=1 else id_tbl_situacao = ' + inttostr(form1.cbo_sit.dbItemID)+' end and'+
' case when length("'+form1.cbo_status.text+'") = 0 then 1=1 else id_tbl_status = ' + inttostr(form1.cbo_status.dbItemID)+' end'+
' ORDER BY Data ASC', Results);
while not Results.Eof do
begin
sData := Results.FieldByName('DMA').asString;
sValue := Results.FieldByName('valor').asString;
if sValue <> '' then
begin
ChartBar.Series[0].AddXY(
x,
StrToFloat(ReplaceStr(sValue, '.', ',')),
sData,
RandomColor()
);
// acumula p/ regressão linear
sumX := sumX + x;
sumY := sumY + StrToFloat(ReplaceStrEx(sValue, '.', ','));
sumXY := sumXY + (x * StrToFloat(ReplaceStrEx(sValue, '.', ',')));
sumX2 := sumX2 + (x * x);
Inc(n);
if n = 1 then firstX := x;
lastX := x;
end;
Results.Next;
Inc(x);
end;
// calcula coeficientes da reta
if n > 1 then
begin
a := (n*sumXY - sumX*sumY) / (n*sumX2 - sumX*sumX); // inclinação
b := (sumY - a*sumX) / n; // intercepto
// adiciona 2 pontos extremos p/ desenhar linha de tendência
ChartBar.Series[1].AddXY(firstX, a*firstX + b, 'Tendência', clRed);
ChartBar.Series[1].AddXY(lastX, a*lastX + b, '', clRed);
end;
ChartBar.Series[0].Title := 'Valores';
ChartBar.Series[1].Title := 'Tendência';
end;
function ReplaceStrEx(AText, FromText, ToText: string): string;
var //*** Proc 60 - replace por Dmitry
ArStr: array of string;
i, c: integer;
begin
ArStr := SplitString(FromText, ',');
c := Length(ArStr)-1;
for i := 0 to c do
begin
AText := ReplaceStr(AText, ArStr[i], ToText);
end;
result := AText;
end;
function RandomColor: TColor;
begin // Função para gerar uma cor aleatória em barras dos gráficos
Result := RGB(Random(256), Random(256), Random(256));
end;