Best way to show xy chart data

[Noisy Cricket]

Hi all,

Trying my best to create a procedure that parses a textile in excel and reads the data to Visio before dropping specific shapes onto the page.

Now, I'd like to create an xy chart from a range of data in excel and display the chart at a given location on my visio page.....
Similarly, I'd like to add a n,5 cell table in excel, populated with excel data.

Can either of this be done using VBA running from Visio? (i'm able to startup Excel and open a sheet.....)

My alternative for the chart is to use a polyline shape but this is slightly tedious and misses the axis'

All help is welcome.

Thanks for considering!

[lindir]

Hi,

Or you could alway plot the graph in excel, insert an excel object in order to display the plot.

Otherwise you can plot the line form the data with shapsheet formula and some vba but this is fastidious....