Hi All,

I want to create one macro , which takes the values from the excel columns
and need to display one Chart dynamically . That is either Bar or pi Charts
with the values which will be printed in the Columns .
The chart need to be displayed in Chart1 Page of same Excel sheet . Is there any way to fire the Macro automatically to generate the Chart ?

Iam new to excel Programming but Iwant this functionality through my Java.
So I want to create one Macro for this.

Thanks in Advance