Creating a Macro to Draw a single stacked column graph with variable inputs

[karloz]

Hi all,

Firstly i'm using Excel 2007.... Not sure if that matters or not though....

This is really starting to confuse me!

I'm creating a SS which tracks a stockpile of material. this ends up in a summary section which will vary in rows depenidng on what material is on the stockpile at any one time. Some Macro's sit in the background doing the grunt work, so the SS doesnt end up too large and cumbersome....

To keep it so little grubby fingers dont alter anything on the SS, i'm looking for a macro that would assist me with creating these graphs without me harwiring in 15 rows (think this should be enough rows), as i want a data table below the graph and it just looks ugly.....

I've tried recording a macro, but it just turns out painfull, and still hard codes it in.... What i really need is like a loop untill it doesnt find any more data below, at which point it finishes the graph...

Is this possiable??? If not i'll do it the other way.

Thank you in advance.....

Karl

[karloz]

Any one got a suggestion for this one?? Its still bugging me significantly!