Issue on Fast change Chart Type.

[jsingh71]

I have created one Pie chart and select 3 more chart type Bar, Line and Pivot as Fast change.

Now is there any way available every time when user comes on this tab by default chart always show as a Pie chart.

[#2]

try to use macro (on sheet activate)

sub SetAsPieChart

    set chart = ActiveDocument.GetSheetObject("CH01")

        chart.SetChartType  1

end sub

below extended list of all types :

Bar 0

Pie 1

Pivot 2

Scatter 6

Line 4

Straight Table 5

[Anonymous]

Hi,

I would like to join to this discussion,

where from can i take list of types of all charts?

It is any documentation or can i get this from VBA ?

Please help,

Best Regards,

Jacek Antek