Sum In the chart area

[akbar]

Dear All,
Please find the attached sheet. i want to know
whether is it possible to auto sum all the % values in that chart,can it be in the
chart title area.

Regards,
Akbar

[Leith Ross]

Hello Akbar,

You need to include your chart data. It is a bit difficult to see the chart as it should be without the data.

Thanks,
Leith Ross

[akbar]

Leith,
i've attached a new sheet & Could you please tell me to do that,if possible.
just need to add all the % Values together.

Regards,
Akbar

[Leith Ross]

Hello Akbar,

The attached workbook has the macro added to add the sum of the percentages to the chart. The macro runs whenever the Chart is updated. The macro is called from the Chart_Calculate event.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[akbar]

Thanks Leith,it works perfectly fine.

Appreciate your effort.

Regards,
Akbar

[akbar]

Lieth,
How can i run the macro automatically,whenever i update my sheets,
its not updating automatically,every time i've go to macros and run it manually.

Regards,
Akbar