Hi all,
Please see attached spreadsheet as example. I want the chart to be dynamic, but as I select a load of blank cells, it shows a number instead of the field name. It will only pull through the field name if i select cells with data in them. I dont want to keep going back and changing the area for the graph, is there a way of automating that?
All help would be appreciated.
Thanks,
Om
Bookmarks