09:10
NASIR ALI
Create Chart Using Chart Wizard MS Office Pictorial representation of data is called graph or chart. Graphs are represented by horizontal and vertical axis, showing constant and values thereof respectively.
Different types of charts are:
Column chart: Column chart contains vertical columns called bars which show values of item. This type is used when we want to create chart of multiple data series.
Bar Chart: Bar chart is represented horizontally.
Line Chart: In line chart, values are connected through lines and upward and downward trends are explained explicitly.
Pie Chart: When data is subdivided into parts, it is more appropriately shown by pie chart which is circular in shape. XY Chart: In XY chart numeric vales are used at both the horizontal and vertical sides.
Different types of charts are:
Column chart: Column chart contains vertical columns called bars which show values of item. This type is used when we want to create chart of multiple data series.
Bar Chart: Bar chart is represented horizontally.
Line Chart: In line chart, values are connected through lines and upward and downward trends are explained explicitly.
Pie Chart: When data is subdivided into parts, it is more appropriately shown by pie chart which is circular in shape. XY Chart: In XY chart numeric vales are used at both the horizontal and vertical sides.
Creating simple chart
To create chart:
Go to Insert < Chart
This chart wizard create chart in simple four
steps.
1. Select chart type
2. Define range
3. Define features like title, legends
4. Define location in spreadsheet
4. Creating pie chart
To create pie chart:
1-Select range
2-Click on Insert < chart
3. Select chart type
4. Define legends, labels etc
To create chart:
Go to Insert < Chart
This chart wizard create chart in simple four
steps.
1. Select chart type
2. Define range
3. Define features like title, legends
4. Define location in spreadsheet
4. Creating pie chart
To create pie chart:
1-Select range
2-Click on Insert < chart
3. Select chart type
4. Define legends, labels etc
Change the chart type
To change existing chart
1-Select chart
2- Right click < chart type
3- Select chart type
6-Add/remove chart title, legends
To change chart title
To change existing chart
1-Select chart
2- Right click < chart type
3- Select chart type
6-Add/remove chart title, legends
To change chart title
Select chart
2- Click on Chart < Chart option You can change chart title, axis, legends, and labels from here.
2- Click on Chart < Chart option You can change chart title, axis, legends, and labels from here.
Change background color in chart
To change background color in chart
1- select chart
2- Click on Format < selected chart area
To change background color in chart
1- select chart
2- Click on Format < selected chart area
Formatting chart
We can change chart data, labels etc after making the chart .We can format chart data together or separately.
To format the chart
1- Select chart.
2- Click on Format < selected chart area
We can change chart data, labels etc after making the chart .We can format chart data together or separately.
To format the chart
1- Select chart.
2- Click on Format < selected chart area
This will open a dialogue box from which we can change font, color, style etc.
