Dynamic charts

[FuzzyD]

Hi All,
I need to create a presentation in PowerPoint that requires me to produce
charts that dynamic change.
The problem is that the numbers that drive the charts have got to embedded
into text on the presentation page layout and not a table.

Can this be done? I've been looking at this problem from a VBA angle but
cannot see how to "call" a chart with VBA

Please help!!

Regards,
Fuzz

 

[FuzzyD]

Hi Steve,
Thanks for your response...and sorry for my late answer!...been too busy of
late.

This will need to run on just about any PC and my VB skills are ok, but not
that strong!
I need to be able to change the data somewhere, and have the charts and the
text in PPT both update to follow it...but this needs to be instantaneous
(without a manual update).

Not sure to the following:

I'm wondering if you could link to a chart in Excel and also link the text
to
the data in the same Excel sheet that drives the chart.

The data and charts are currently Excel...I have tried using PowerPoint
charts too and I haven't even considered MS Graph!!
Most of the users will be using 2003

Ken (fuzz)

 

[FuzzyD]

Thanks Steve.
I shall try the Excel linked to PPT route.
But I am interested in knowing how to create a bar chart (with two bars)
where the data is taken from two number text box/field.

Regards,
Ken