Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lost X-axis after resizing charts using VB - not sure why...
Hi,
I used this code to resize a bunch of charts: Set cellsToCover = Sheet1.Range(cell1 & ":" & cell2) Set chartShape = ActiveChart.Parent chartShape.Height = cellsToCover.Height chartShape.Width = cellsToCover.Width chartShape.Top = cellsToCover.Top chartShape.Left = cellsToCover.Left After resizing, the x axis labels have disappeared, but when I check the chart settings, they are still enabled. I would like to maximize the size of the chart within the border in order to keep the axis in tact. Any ideas on how I could go about this in VB, would be a great help. Thanks, WA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resizing charts | Excel Programming | |||
Resizing many charts | Charts and Charting in Excel | |||
Resizing Charts | Excel Discussion (Misc queries) | |||
Resizing elements of Excel charts | Charts and Charting in Excel | |||
Auto Resizing of Pie Charts | Excel Discussion (Misc queries) |