Change a graph's type by VBA

[MuadDib_II]

Hi all,

I woud like to know if it's possible to change a graph's type, by VBA code. For exemple, i would like to change an histogramme graph into a sector's graph.

thanks in advance for all tips,

 

[DanBurn]

I found the If you just record yourself doing it with a macro in excel it will create the code for you then just drop it in Access

 

[MuadDib_II]

i will try


thanks for your answer