Recent

6/recent/ticker-posts

Header Ads Widget

Create Chart in Excel


Chart in Excel

Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.
To create a chart in Excel, you start by entering the numeric data for the chart on a worksheet. Then you can plot that data into a chart by selecting the chart type that you want to use on the Office Fluent Ribbon (Insert tab,Charts group).
Chart Example


This is sample data for create chart
Create a Column Chart
1.     Select cells A3 to D6. You must select all the cells containing the data you want in your chart. You should also include the data labels.
2.     Choose the Insert tab.
3.     Click the Column button in the Charts group. A list of column chart sub-types types appears.
4.     Click the Clustered Column chart sub-type. Excel creates a Clustered Column chart and the Chart Tools context tabs appear.


Apply a Chart Layout

1.     Click your chart. The Chart Tools become available.
2.     Choose the Design tab.
3.     Click the Quick Layout button in the Chart Layout group. A list of chart layouts appears.
4.     Click Layout 5. Excel applies the layout to your chart.

Switch Data

If you want to change what displays in your chart, you can switch from row data to column data and vice versa.

 



1.     Click your chart. The Chart Tools become available.
2.     Choose the Design tab.
3.     Click the Switch Row/Column button in the Data group. Excel changes the data in your chart.

Change the Style of a Chart

A style is a set of formatting options. You can use a style to change the color and format of your chart. Excel 2007 has several predefined styles that you can use. They are numbered from left to right, starting with 1, which is located in the upper-left corner.
1.     Click your chart. The Chart Tools become available.
2.     Choose the Design tab.
3.     Click the More button More Button in the Chart Styles group. The chart styles appear.
4.     Click Style 42. Excel applies the style to your chart.

Change the Chart Type
Any change you can make to a chart that is embedded in a worksheet, you can also make to a chart sheet. For example, you can change the chart type from a column chart to a bar chart.

1.     Click your chart. The Chart Tools become available.
2.     Choose the Design tab.
3.     Click Change Chart Type in the Type group. The Chart Type dialog box appears.
4.     Click Bar.
5.     Click Clustered Horizontal Cylinder.
6.     Click OK. Excel changes your chart type.


Post a Comment

0 Comments