14 июл. 2020 г. · I need to re-scale the Y-axis of my charts in an excel sheet. The scale should be adjusted by the values inside each chart.

28 апр. 2020 г. · VBA doesn't have chart subtypes, and controls the chart type using this syntax: ActiveChart.ChartType = xlColumnClustered ActiveChart.ChartType = ...

20 авг. 2015 г. · I would like to use vba to change a pie chart to a bar chart and vice versa. I have used this code from a similar question but it does not seem to work.

16 авг. 2011 г. · I am trying to create a chart programmatically in VBA. The chart needs to have 3 series, with 2 series being xlColumnStacked and 1 series being ...

20 мар. 2020 г. · Loop through sheets and graphs setting chart type (xlLine), series weight, series colors, chart legend (down), Chart height and width.

7 авг. 2016 г. · You can use a number from 1 to 48 to set the chart style. My test shows that range 201 to 352 is valid as well. This is across all chart types.

24 июл. 2023 г. · Try recording your macro by first creating a blank chart, and then selecting the groups of data exactly as you'd like rather than as a bulk group.

6 дек. 2017 г. · How do I adjust the code below to create a combo chart with a bar for the primary axis and line for the secondary axis? I have two columns of data.

5 мая 2017 г. · I have a code the copying the range to a certain cell and change the data source to the chart. the chart has combination chart type, which ...

1 февр. 2018 г. · I am working on a larger project that involves making a worksheet with up to 100 different charts (in this case XY scatter charts).