Editing Charts with the mouse

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, Excel and tagged , , . Bookmark the permalink.

4 Responses to Editing Charts with the mouse

  1. ihuitsonHui says:

    Long gone is also applying Goal Seek by dragging a point in a chart.
    Chopped out when Excel 2007 was introduced


    • dougaj4 says:

      Hi Hui. I never actually used that one (having come from many years of Lotus 123, which didn’t have that feature). I’m not actually sure I like the idea of dragging points on charts changing data. Could you switch it off?


  2. AH says:

    That’s a shame. Moving points on a chart by dragging with the mouse is exactly what I would like to do! Let me know if there’s a still a way …


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s