Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you show plot area only-no chart area | Charts and Charting in Excel | |||
Resize plot area in a chart area | Excel Discussion (Misc queries) | |||
Question about different paste area sizes | Excel Discussion (Misc queries) | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel |