Hi
I have set up a spreadsheet to record the length of time that people take to complete their competition rounds at my golf club. I use a simply bar chart to show the round time on the vertical axis against the start time on the horizontal axis.
Start times are spaced at regular 8 minute intervals but the number of start times can vary from one competition to another. For example one competition may run from 8am to 1pm, another from 9am to 3pm. It is easy enough to "parameterise" the actual table of results to show only the start times used on the day but I am struggling to automate my chart so that it displays data points ONLY for the times included in each competition. For example if my first competition contains 10 start times then if the next one includes 20 I have to go into the chart settings and extend the data ranges if the next one has 15 data points then I have to go in and restrict the ranges.
I have tried using the INDIRECT function to specify the data ranges in the chart settings but that doesn't seem to work.
It sounds like such an obvious thing to want to do in all types of scenarios - am I missing something.
Cheers.
Dave.
Bookmarks