Make Charting Easier!!
Do you know how you can toggle the way a function is locked by hitting Fn-F4, and A4 goes to $A$4, to A$4, to $A4, to A4 again? I want that kind of feature for charting!
So if I select two random columns and hit LINE GRAPH, Excel should give me a line graph quickly, then if I find the axes are wrong, I should be able to switch them by hitting FnF4, and then switch them again by hitting the same function again.
The same should be true of any other thpe of graph, I should be able to build any graph hassle free, by selecting a couple random columns and hitting graph, and if I find the aces are wrong, I should be rapidly able to toggle through the other possible variance of the graph axes etc...
Check out the “Switch Row/Column” button on the Chart Design ribbon when you have a chart selected.
Hope that helps,