MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Embemded charts in Excel


Posted by simon on August 01, 2001 7:35 AM

Hi everybody

Here is my problem. I have IFIX that can work with VBA. So with it, I can open an Excel
session, create a workbook, a sheet and an embemded chart. But the scaling is not OK.
So i'm trying to make the category axis labels "not visible" to make the labels disapear. But I can find a proper
VBA command to do that. I must absolutely do it with VBA. I have tried the .HasDisplayUnitLabel
property for the axis object but apparently, it does not work for an embemded chart, only for
sheet-chart.

Can somebody help me on this ? Thank you!


Posted by Mark W. on August 01, 2001 8:20 AM

Can you use...

ActiveChart.HasAxis(xlCategory, xlPrimary) = False