I have tried using .ScaleHeight but it changes the height and the width.

Thread starter Lewzerrrr; Start date Oct 31, 2017; Tags entry fixed graph height; L. Lewzerrrr Active Member. Read/write. I found activewindow.width and activewindow.height in VBA's help, but these are not the exact height and width of the Excel worksheet (ie. I do numerous charts and would like a macro that when I select a chart it resizes it based on pre-determined code. Can you post an example of the chart and describe how to make it unclear? Oct 31, 2017 #1 Hey, I created a 2d column graph that’s dynamic based up on a drop down list. In VBA, height and width properties are specified in points as units. Some of … Automatically adjusting chart height VBA. Hi, There is nothing automatic so the code is going to need some clues as to what constitutes an unclear chart. To keep the aspect ratio the same, we would multiple height by the same height-to-width ratios. Item: Chart. In order to get to the Series without an exisitng chart, you create a ChartObject on a given Worksheet and then get the Chart object from it. One inch is equal to 72 points. Quick Excel Chart VBA Examples . Description: The Shape.Chart property returns a Chart object representing the chart contained within the shape. The upside of working with the Series object is that you can set the Values and XValues by referring to Range objects. Re: autosize chart. With VBA I am creating charts in Excel as pasting them to Powerpoint. Joined Jan 18, 2017 Messages 251. Name chartobjects.Add(Left, Top, Width, Height) Synopsis Creates a blank, embedded chart on the worksheet or chart sheet. Set Column Width with VBA Macro to set the column… This example sets the height for row two in the specified table to 100 points (72 points per inch).
Returns or sets the height of the specified object, in points. Because of the above, “ChartDestination.Height” sets the height of the newly-created clustered or stacked bar chart to be the height of ChartDestination. Now, I need to make them taller but not change the width. (So if shp.Height = 1 means height is set as 1 point.) You can use ChartObject Collection to loop through the all charts in worksheet or workbook using Excel VBA. For information the following would make the chart 10% wider and taller[vba]activechart.Parent.width=activechart.Parent.width*1.1 and on that page they specifically show an example and referring to the fact, that 1 inch has 72 points. Many of my charts go into Powerpoint and I generally use one of three sizes: kind of a small, medium and large thing. Here are Excel Chart VBA Examples to deal with Charts using VBA… Charts can be created by working directly with the Series object that defines the chart data.


VBA construct: Shape.Chart property.