Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

charttype, convert numbers to constants

Status
Not open for further replies.

RodP

Programmer
Jan 9, 2001
109
GB
Hi All,

I have a chart object in which I want to get it's charttype. Currently it returns a number and I'd like to know how to convert it to it's constant's name. Do i need to make up an array mayself to do this as i can't seem to find a ...charttype.name or ....charttype.label

For example the xlDoughnutExploded (pie chart) I have is returning 80 in the message box.

private sub chart-it()

Dim cht as object
For Each cht In ActiveSheet.ChartObjects
msgbox cht.chart.charttype
next

end sub

Hope someone can help

Many thanks in advance

RodP
 
Either copy values and corresponding descriptions from object browser into your own function or use tybelib info object (see thread707-1312283 for instance).

combo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top