When editing chart ranges, to either change the limits of the range, or select a new column, I have been in the habit of either selecting a range and editing the text in the Formula Edit Bar, or right clicking, choose “select data”, and using the Select Data Dialog.
But there is an easier way:
Select a graph range and the data columns are highlighted:
The ranges can now be extended by simply dragging the corner to the required row:
The selected column can then be dragged across to another column:
Repeat for each data range:
and the job is done.
This entry was posted in Charts
and tagged Charts
, Editing Charts
. Bookmark the permalink