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

 

[Steve Rindsberg]

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.

Do you need to be able to edit the text on the PPT slide and see the charts
change, or do you need to be able to change the data somewhere, and have the
chart and the text in PPT both update to follow it?

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.

If not, fill in some more info:

Is the chart in Excel or MSGraph?

Do you need to be able to support 2007?

Can you install an add-in of your own making on the machines where this'll work
or does it need to run on pretty much any computer?

How're your VBA skills? This might not be rocket science, but it's not a
beginner's project.

 

[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)

 

[Steve Rindsberg]

Hi Ken

This will need to run on just about any PC and my VB skills are ok, but not
that strong!

Writing the VB is do-able but not all that simple, but it may not run on a lot
of PCs due to PPT macro security settings, and won't run at all on PCs where
the user's only got the PPT Viewer and not the full PPT.

Sounds like VB's a non-starter.

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).

Text and charts linked from a spreadsheet would work, so long as you supplied
the spreadsheet along with the PPT file (or rather, it'd work in full PPT ...
again, not in the Viewer). And the users will probably see a prompt asking if
it's ok to update.

The data and charts are currently Excel...I have tried using PowerPoint
charts too and I haven't even considered MS Graph!!

MSGraph = PPT Charts. When you insert a chart in PPT, an MSGraph chart is what
you get, at least in PPT 2003 and prior.

So I'd do some testing with Excel, both text and charts linked into PPT.

 

[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

 

[Steve Rindsberg]

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.

Have a look here for something to get you started:

Working with MSGraph charts
http://www.pptfaq.com/index.html#name_Working_with_MSGraph_charts