ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   plot area inconsistent sizes with VBA (https://www.excelbanter.com/charts-charting-excel/213735-plot-area-inconsistent-sizes-vba.html)

Robert H

plot area inconsistent sizes with VBA
 
I run a series of charts on a single sheet that look at different but
similar types of data. the x-axis values are always the same. The y-
axis is the same count but different ranges of values. The charts are
set to be the same size and the plots are set to be the same size. On
some of the resulting charts the plot height is slightly smaller and
the plot width is about half even though the the plot areas are full
size.

here is the segment of code

With .Parent
.Top = chtLoc1.Offset(26, 0).Top
.Left = chtLoc1.Left
.Height = 252
.Width = 432
.Name = chtNm
End With


With ActiveChart.PlotArea
.Top = 20
.Height = 221
.Left = 0
.Width = 340
End With

the inconstancies occur at .plotarea.height and .width

I thing there must be another setting that is unique to the two charts
that this occurs on. the same code is cycled through to create each
chart.

Thanks
Robert


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com