![]() ![]() Here is code recorded while I added a waterfall chart and set three of the bars to totals: Sub Macro1()Ī2(395, xlWaterfall).SelectĪctiveSheet.ChartObjects("Chart 1").ActivateĪctiveChart.FullSeriesCollection(1).SelectĪctiveChart.FullSeriesCollection(1).Points(1).SelectĪctiveChart.FullSeriesCollection(1).Points(1).IsTotal = TrueĪctiveChart.FullSeriesCollection(1).Points(4).SelectĪctiveChart.FullSeriesCollection(1).Points(4).IsTotal = TrueĪctiveChart.FullSeriesCollection(1).Points(7).SelectĪctiveChart.FullSeriesCollection(1).Points(7).IsTotal = TrueĪpplication.CommandBars("Accessibility").Visible = False In the latest Office 365 Insider build, the macro recorder is aware of waterfall charts.
0 Comments
Leave a Reply. |