Set chart type as Column in VB

[Abishek@0611]

Is there any way to set chart type as column chart and modify its shape to cylinder from Box?

[JeJe]

This is the same question as your other thread - what was wrong with the answer you got there?

viewtopic.php?p=538612#p538612

[Cazer]

You can use the XlChartType enumeration in VB to set the chart type and shape. For example, if you want a 3D cylinder column chart, you would use the xlCylinderCol value which is 98. Here's the link to the official Microsoft documentation that provides a full list of available chart types and their corresponding values:https://learn.microsoft.com/en-us/offic ... lcharttype

[Abishek@0611]

I Need to do this using Open office i have done this with Excel already, is there any possible way to have chart like this in open office through VB.

[Bidouille]

VB = Microsoft
Do it with (native) StarBasic.
Studdy this snippet code: viewtopic.php?t=88567

If you do not achieve this, attach a document.

[Abishek@0611]

https://www.openoffice.org/api/docs/com ... le-ix.html ---> has anyone tried using this in your code

[Bidouille]

Did you read my last post?