More efficient process for changing data for graphs
Here’s an idea… When changing the coordinates for a graph using “Select Data” after right clicking in the graph, it is great that the view switches to the actual data so that ranges can be easily selected. However, it would be even better if the view returns to the graph on leaving the “Select Data” dialog box. Often I have very large databases with the data I want to graph, often 40 or more for a single report. SO MUCH time is spent going back and forth between graphs and data, which are usually on different sheets, if not in different workbooks. So searching for the graph I am working on ofeten takes a long time.