Tame your computer – data additions

24 Oct

After you create a chart in Excel (F11, anyone?) you might need to add new, additional data to the existing graph. As always, there are various ways to do this. I personally feel Microsoft has over-complicated the Select Data option in the Data group on the Design tab. If the chart is stored on the same sheet as the data, you can simply drag the “sizing handles” to add the new data.

But if the chart is on a separate chart sheet or you don’t understand what I mean with or cannot see the sizing handles, you can copy the additional worksheet data into the chart.

Here’s how:

  1. On the worksheet, select the cells that contain the data that you want to add to the chart.
  2. Copy, as normal. (CTRL + C)?
  3. Select the chart or go to the chart sheet into which you want to paste the copied data.
  4. Press ENTER or CTRL + V.

By the way, have you ever noticed that as soon as you copy something, Excel is telling you what to do on the Status Bar in the bottom left corner of the screen? Select destination and press ENTER or choose Paste.

* Unless stated otherwise, these tips were written for Microsoft Office 2010.

Advertisements

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

%d bloggers like this: