Working with Chart

To create a chart 

What is a Chart?

A chart is a diagram or an effective tool you use in Excel in exchange graphically with data you have in a given table.

It is simple to easily create a chart in Excel.Excel application enables you to create a different chart types to choose from the chart dialog box. Get more information about different chart types

Design the data you arrange in rows or columns on a worksheet in a column or row bar chart while chart like pie and bubble require a specific data arrangement.

Available Chart Types

To insert a chart

Make sure that you arrange the data that you want to plot in a chart or in the worksheet.

Remember to select cells that you want to include in the chart including column titles and row labels

In this example we use the Students Score Report

Click on the Insert tab

Point each of the Chart option in the Charts group to learn more about it.

Select and Click on any of the chart sheet to select it and to display the chart tools.

In the Location group, click Move Chart on the Design tab

Choose where you want the chart to be placed

·    Click on New sheet to display the chart in a chart sheet

·   To display the chart as an embedded chart in a worksheet,

   click Object in, and

   click a worksheet in the Object in box.

   Sample of a Column Chart

TIPS  

·   I use to type a new name in the New sheet box to replace the suggested name for the chart.

·       To quickly create a chart that is based on the default chart type, I always select the data that I want to use for the chart, then I press ALT+F1 or F11 on the keyboard to quickly create chart based on default type, chart is displayed as an embedded chart. But when F11 is press the chart is displayed on a separate chart sheet.

·       When using a specific chart type frequently creating a chart may set that chart type as the default chart type. After you select the chart type and chart sub type in the Insert Chart dialog box, click Set as Default Chart.

·  When I create a chart, the chart tools become available and the Design, Layout, and Format tabs are displayed. I use the commands on these tabs to modify the chart so that it presents the data the way that I want. 

 For example, I use the Design tab to display the data series by row or by column, I make changes to the source data of the chart, change the location of the chart, change the chart type, save a chart as a template, or select predefined layout and formatting options. 

 I also use the Layout tab to change the display of chart elements such as chart titles and data labels, use drawing tools, or add text boxes and pictures to the chart. I use the Format tab to add fill colors, change linestyles, or apply special effects.

See Also

• Overview of charting
• Change the layout or style of a chart
• Available chart types
• Change the chart type of an existing chart