Dynamic graph problem

[clintonmadden]

Hi,

I have been trying to create a dynamic graph that will update when data is entered into it. I found a good tutorial which works and have created a spreadsheet for displaying sickness. I now want to add in a trust target line of 3.25% to the bar chart but only want to display this for months when data is entered into the sickness % cell. Is there any way I can do this? I have attached the spreadsheet I've been working on.


Thanks in advance for any help you could give me.

 

[lemo]

i think you just need to define the 'trust target' line dynamically, as you did with the 'sickness %' columns.
try this definition -
=OFFSET(Sheet1!$C$5,0,0,COUNTA(Sheet1!$B:$B))

l

 

[clintonmadden]

Hi Lemo, thanks for your reply. The formula you suggested did the job, thanks very much.