Re^2: Excel Chart

Instead of hard coding as " categories => '='."$worksheet".'!$B$1:$E$1' ", Can we make it dynamic to select the range of cells to plot the chart? Any idea how to make it dynamic?

Comment on Re^2: Excel Chart

Replies are listed 'Best First'.
Re^3: Excel Chart by Corion (Patriarch) on May 31, 2016 at 08:20 UTC
Making the range dynamic is as easy as constructing the appropriate string for the range.	[reply]
Re^3: Excel Chart by davies (Monsignor) on May 31, 2016 at 10:55 UTC
Have a look at Re^3: Win32::Ole excel external data range, in which I show the use of dynamic ranges. It does other things too (it's answering a different question), but I think it's reasonably clear. Regards, John Davies	[reply]