MS Excel: Charts. In Microsoft Excel, a chart is often called a graph. A chart is a powerful tool that allows you to visually display data in a variety of different chart formats such as Bar, Column, Pie, Line, Area, Doughnut, Scatter, Surface, or Radar charts. With Excel, it is easy to create a chart. Create a chart (graph) that is recommended for your data, almost as fast as using the chart wizard that is no longer available.
Create a chart
- Select the data for which you want to create a chart.
- Click INSERT > Recommended Charts.
- On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look.If you don’t see a chart you like, click All Charts to see all the available chart types.
- When you find the chart you like, click it > OK.
Use the Chart Elements, Chart Styles, and Chart Filters buttons, next to the upper-right corner of the chart to add chart elements like axis titles or data labels, customize the look of your chart, or change the data that is shown in the chart.
- To access additional design and formatting features, click anywhere in the chart to add the CHART TOOLS to the ribbon, and then click the options you want on the DESIGN and FORMAT tabs.
Add a trendline
- Select a chart.
- Select Design > Add Chart Element.
Select Trendline and then select the type of trendline you want, such as Linear, Exponential, Linear Forecast, or Moving Average.
You may wish to contact us for detail MS Excel Practical Training.