Dynamic charting in Excel 2003

**Ace_XL** · 07-06-2012, 04:58 PM

Use dynamic named ranges for each of the Columns A,B,C & D using the OFFSET function, whereby the range would determine only the continuous non-blank rows i.e. the number of rows would depend on count of non-blank continuous rows calculated in a helper cell.
Populate your chart based on the named ranges then. Perhaps a sample worksheet would aid in demonstrating better

**Roberthorse** · 07-07-2012, 01:03 PM

Thanks very much for your post.
Could you send me a sample spreadsheet with the chart on it with the OFFSET function up and running so I can get my head round it?

Regards, Rob

"Use dynamic named ranges for each of the Columns A,B,C & D using the OFFSET function, whereby the range would determine only the continuous non-blank rows i.e. the number of rows would depend on count of non-blank continuous rows calculated in a helper cell.
Populate your chart based on the named ranges then. Perhaps a sample worksheet would aid in demonstrating better"

**oeldere** · 07-07-2012, 02:01 PM

Could you send me a sample spreadsheet with the chart on it with the OFFSET function up and running so

I can't help you with the question.

But you want help, why don't you post an example (instead of asking the forummembers to make an example).

**Roberthorse** · 07-07-2012, 04:09 PM

I attach an example of the problem. Could you edit the chart for me so it responds to new information appearing in the columns in the highlighted area without the graph lines going to zero on the right hand side? There's a cell above where you can put in a number between say 4 and 10 and see new data appear and disappear. Or if you prefer could you send me your own example so I can get my head round it?

Regards, Rob

"Use dynamic named ranges for each of the Columns A,B,C & D using the OFFSET function, whereby the range would determine only the continuous non-blank rows i.e. the number of rows would depend on count of non-blank continuous rows calculated in a helper cell.
Populate your chart based on the named ranges then. Perhaps a sample worksheet would aid in demonstrating better"

**Roberthorse** · 07-07-2012, 04:35 PM

Hi Ace-XL...Just read your post and downloaded your file [after I'd uploaded mine !] for which I thank you. The chart looks like it does exactly what I want...Unfortunately you start too high up the ladder for me! Do you know where I can find information telling me step by step how to set it up? For example I can't fathom out how the count formulae in F.1 to I.1 are linked to the Chart etc etc ?

Thanks for your assistance.