Graph moving data range

[m17347047711116]

I have a bar graph that i have made with 2 sets of series one represents staff required every 15 minutes and the other series represents number of staff scheduled every 15 minutes.

Problem looks great when i go in and change the series range each week as the start time of the shift is always changing,

is there a way that if the staff required = 0 and the staff scheduled = 0, that the graph will not show the empty time slots, it takes up alot of room and confuses everyone. I only want the graph to start where there is someone required or there is someone scheduled

 

[PaddyD]

If you mean 'don't graph points with zero values', custom filter your source data for the graph to exclude zeros - excel will only chart visable cells.

If you mean 'automatically expand chart series as data grows' see

http://www.tushar-mehta.com

for some examples on dynamic charting

Paddy