Creating & Formatting Charts in Excel

28 Dec 2011 by Phil Beach
Posted in: The Point

Trouble viewing the screencast at work? Try signing up for The Point on our home page with your personal email address and watch the screencast from home.

Creating charts in Microsoft Excel 2010 can be confusing at first. However, with a few short lessons they're a simple task. FollowAlong with the steps below to learn how to create and format charts.

Creating Charts

1. First, select the Insert tab on the top of Excel
2. From the Charts grouping, choose the type of chart you wish to create. In this example, we use a 2-D Column chart

   

3. A blank chart will appear, from the Data grouping, choose Select Data

   

4. Click inside the box labeled Chart data range:, then click and drag to select those cells in Excel that contain your chart data

   

5. Click OK

Formatting Charts

• To format a specific part of the chart, simply double-click that part of the chart. A window similar to this will appear:

  

• To delete a specific part of the chart, click it once, then press Delete on your keyboard

If you have an unanswered technical question that you would like to see appear in an upcoming issue of The Point, feel free to call or email it to .(JavaScript must be enabled to view this email address) - 973.448.0070 ext. 323.

SEARCH

Select Category Community Development IBM Linux Magazine IT Support The Point Videos

Select Month March 2012 February 2012 January 2012 December 2011 November 2011 October 2011 August 2011 July 2011 June 2011 May 2011 April 2011 March 2011 February 2011 January 2011 December 2010 November 2010 October 2010 September 2010 August 2010 July 2010 June 2010 May 2010 April 2010 March 2010 February 2010 January 2010 December 2009 November 2009 October 2009 September 2009 August 2009

Select Author Phil BeachFrank AblesonBarry McGuire

HOW TO VIDEOS

Creating Contact Groups in Google Apps and Gmail

How To Setup Filters in Google Apps & Gmail