If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
Hi,
I've recently moved "up" to Xl2007 and have a question about selecting series values for charts.
In earlier versions of XL I'm pretty sure I could modify the series values reference by selecting the series in the chart, highlight the series reference in the formula bar and then using control keys (e.g. CTRL+Shift+ Down Arrow) change the series values reference range.
In XL2007 trying to modify the series by using the control keys does not work and now I'm wondering if I'm just imagining that I could do this in earlier versions.
Two or three key strokes is much, much quicker than using the mouse or typing a new range.
Am I right, and this method is no longer available or just 'mis-remembering' ??
Last edited by Jbentley; 07-05-2009 at 01:09 AM.
Reason: solved
Selecting Chart Series Values in Xl2007
Linear Mode
