Topic: Making text bold and set colors on MS Chart control

[iliekater]

 Recently I discovered the MSChart control . It looks great , but I have a problem . I want to show a bold text at the bottom of the control , so I use the following code :

Code: [Select]

MyForm.MSChart.Footnote.Location.LocationType = VtChLocationTypeBottom
MyForm.MSChart.Footnote.Font.Bold = True
Although I manage to specify the position of the text (at the bottom) , I get an error message at the second line saying :

Property is write only .

What does it mean ? I press the Help button , but MSDN informs that I should create my own functions for handling the MSChart's errors . Yeah , thanks alot .
The strange thing is that I can actually make the text bold through the manual procedure (right click on the control > Properties > and so on ...) . But I want to do that by code . Is there a way ?

The other thing I can't do by code (but can do manually - but it's not what I want) , is to set the color for each of the columns . Does anyone know ho this is possible ?

[Kerry]

...............

Property is write only .

...........

Do you mean Read Only ??

[iliekater]

Nope ! I literaly meant "write-only" ! Here's the proof . In fact two proofs :

1) During execution :


2) In debug mode (see the yellow pop-up message) :

[HarleyHetz]

Try doing a "Debug.Print" on the property...just to see if it will "read" it.
Debug.Print THERMAL_Chart.MSChartTHERMAL.Footnote.Font.Bold

[DaveW]

If a property is write-only, then you can't retreive it. You can only set it.
Try using Let or Set

[iliekater]

Nope , all negativ . Oh well , I quess I'll have to do that manually .