Hi all, hopefully a simple one.
I have a sheet of data that is updated on a regular basis. Therefore at the moment lines 2-55 are populated, but lines 56-700 are not yet (but will be over time)
I want to create a 'dashboard' tab which displays charts based on data on my first tab, but want it to update based on the data as and when it gets populated.
I know I can do this with a Pivot table and a quick refresh, but is there a way to bypass that and create a chart, looking just at cells with data (i.e. currently lines 2-55 but in a week, lines 2-66, excluding anything else below that which is blank?).
Thanks!
I have a sheet of data that is updated on a regular basis. Therefore at the moment lines 2-55 are populated, but lines 56-700 are not yet (but will be over time)
I want to create a 'dashboard' tab which displays charts based on data on my first tab, but want it to update based on the data as and when it gets populated.
I know I can do this with a Pivot table and a quick refresh, but is there a way to bypass that and create a chart, looking just at cells with data (i.e. currently lines 2-55 but in a week, lines 2-66, excluding anything else below that which is blank?).
Thanks!
