Add horizontal line in excel pivot chart

Add horizontal line in excel pivot chart full#

Add '% CROSTE LATERALI', '='Somma di CROSTE LATERALI' /'prod. Add '% SCARTO CREPE', '='Somma di CREPE' /'prod. Add '% SCARTO FORCHE', '='Somma di FORCHE MULETTO'/'prod. Add '% SCARTO BORDO LATERALE', '='Somma di BORDO LATERALE' /'prod. Add '% TOTALE SCARTI', '='TOTALE SCARTI'/'prod. Add '% CAUSA TAGLIO', '='SCARTI TAGLIO'/'prod. Add '% CAUSA FOAM', '='SCARTI CONVEYOR'/'prod. Add '% SCARTO BASSE', '='Somma di LASTRE BASSE' /'prod. Add '% SCARTO VENATURE', '='Somma di VENATURE' /'prod. Add '% SCARTO BUCHI', '='Somma di BUCHI'/'prod. With ActiveSheet.PivotTables('Tabella_pivot1').CalculatedFields

With ActiveSheet.PivotTables('Tabella_pivot1').PivotFields('anno') With ActiveSheet.PivotTables('Tabella_pivot1').PivotFields('Mese') With ActiveSheet.PivotTables('Tabella_pivot1').PivotFields('Anno') SetSourceData Source:=Range('conveyor_mese!$A$1:$C$28') 'Tabella_pivot1', DefaultVersion:=xlPivotTableVersion12 TableDestination:='conveyor_mese!R1C1', TableName:= _ 'dati!R1C1:R9999C28', Version:=xlPivotTableVersion12).CreatePivotTable _

Add horizontal line in excel pivot chart full#

I report below full code for two out of fours charts (correction is 8 in one case and 27 in another - I only care vertical position) Sub Macro2()ДЄ(SourceType:=xlDatabase, SourceData:= _ Any idea?Д«asically, it would be easy to place the horizontal line if I knew exact position of the origin (0% on axis y) from the top-left corner which is taken as a reference for the.

PlotArea.Height but I can't find a solution. I tried to create a formula to calculate vertical_position given. Shapes.AddLine(60, vertical_position, 940, vertical_position).Line I would like to add a horizontal line at a target level of 0.7% (target is not fixed, but should be taken from another cell in another sheet: Target = Sheets('equivalenti').Range('N6').Value)Д¬ommand should be something like. I created a pivot chart (chart from pivot table) type xlCylinderColStacked.