23 авг. 2013 г. · You can change the chart name by code using: yourchart.Name = "Name" Or in the worksheet you can select the chart, go to the Layout Tab and in the right edge.

19 мар. 2019 г. · I am trying to create macro that will insert a simple bar chart in Excel. I have the following code which was a result of recording whilst I did it manually.

6 мар. 2016 г. · I am trying to write a macro in Excel VBA that adds a chart and then want to rename it and edit the colors of the columns but somehow it throws a debug error.

6 мар. 2017 г. · I know the name of the chart is chart 1, so was trying to find a way to have the title of chart 1 be set to my string variable.

13 апр. 2015 г. · I simply want to add a chart title to my chart using vba. I actually want to do it recursively for every chart in every sheet, but I can't even get 1 chart to ...

4 нояб. 2014 г. · The AddChart method returns the Shape so you can set a variable this and work with it. Dim s As Shape Set s = ActiveSheet.Shapes.AddChart s.Select s.Name = " ...

3 авг. 2016 г. · You can set the name of the chart to which you intend to refer using the following: ActiveSheet.Shapes(1).name = "Sale"

22 февр. 2017 г. · Select Dim ca As ChartArea, ch As Chart, co As ChartObject Set ca = Selection Set ch = ca.Parent ch.ChartType = xl3DColumn Set co = ch.Parent co ...

27 янв. 2016 г. · I want to format a chart in a new tab based on some existing data from a worksheet. I can record the pattern using Save As Template, but I want to create a ...

29 дек. 2019 г. · ActiveChart.ChartTitle.Text is the property needed for the text. This is a way to refer it in the ActiveChart : ActiveChart.ChartTitle.