Which of the following is added to the ribbon when a chart is inserted into a worksheet?
To insert a chart, select the data you wish to appear in the chart, and then go to the Insert ribbon (if the data is noncontiguous, you can select one set, and hold down the Control key on the keyboard to select the second set). In the Charts group, choose the desired type of chart. Click on the arrow below the type icon to see the sub-types. Excel 2013 also includes an option to browse Recommended Charts, which shows you the chart types that best fit your data. Show By default, the chart will appear directly on the spreadsheet where your data is; when the chart is selected, you will see additional ribbons. In Excel 2010, you have the Design, Layout, and Format Ribbons. In Excel 2013, you have Design and Format. The 'Layout' options have been consolidated into the Design ribbon. Lesson 17: Working with Charts/en/excel2010/using-templates/content/ IntroductionA chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier. In this lesson, you'll learn how to insert charts and modify them so they communicate information effectively. ChartsExcel workbooks can contain a lot of data, and this data can often be difficult to interpret. For example, where are the highest and lowest values? Are the numbers increasing or decreasing? The answers to questions like these can become much clearer when data is represented as a chart. Excel has various types of charts, so you can choose one that most effectively represents your data. Optional: You can download this example for extra practice. Types of chartsClick the arrows in the slideshow below to view examples of some of the types of charts available in Excel.
Identifying the parts of a chartClick the buttons in the interactive below to learn about the different parts of a chart. Horizontal AxisThe horizontal axis, also known as the x axis, is the horizontal part of the chart. In this example, the horizontal axis identifies the categories in the chart, so it is also called the category axis. However, in a bar chart, the vertical axis would be the category axis. LegendThe legend identifies which data series each color on the chart represents. For many charts it is crucial, but for some charts it may not be necessary and can be deleted. In this example, the legend allows viewers to identify the different book genres in the chart. Data SeriesThe data series consists of the related data points in a chart. If there are multiple data series in the chart, each will have a different color or style. Pie charts can only have one data series. In this example, the green columns represent the Romance data series. TitleThe title should clearly describe what the chart is illustrating. Vertical AxisThe vertical axis, also known as the y axis, is the vertical part of the chart. In this example, a column chart, the vertical axis measures the height—or value—of the columns, so it is also called the value axis. However, in a bar chart, the horizontal axis would be the value axis. To create a chart:
Chart toolsOnce you insert a chart, a set of chart tools arranged into three tabs will appear on the Ribbon. These are only visible when the chart is selected. You can use these three tabs to modify your chart. The Design, Layout and Format tabsTo change chart type:
To switch row and column data:Sometimes when you create a chart, the data may not be grouped the way you want. In the clustered column chart below, the Book Sales statistics are grouped by Fiction and Non-Fiction, with a column for each year. However, you can also switch the row and column data so the chart will group the statistics by year, with columns for Fiction and Non-Fiction. In both cases, the chart contains the same data—it's just organized differently. Book Sales, grouped by Fiction/Non-Fiction
To change chart layout:
Some layouts include chart titles, axes, or legend labels. To change them, place the insertion point in the text and begin typing. To change chart style:
To move the chart to a different worksheet:
Keeping charts up to dateBy default, when you add more data to your spreadsheet, the chart may not include the new data. To fix this, you can adjust the
data range. Simply click the chart, and it will highlight the data range in your spreadsheet. You can then click and drag the handle in the lower-right corner to change the data range. If you frequently add more data to your spreadsheet, it may become tedious to update the data range. Luckily, there is an easier way. Simply format your source data as a table, then create a chart based on that table. When you add more data below the table, it will automatically be included in both the table and the chart, keeping everything consistent and up to date. Watch the video below to learn how to use tables to keep charts up to date. Challenge!
/en/excel2010/working-with-sparklines/content/ Which tab of ribbon is used for inserting chart?On the Insert tab, in the Illustrations group, click Chart. In the Insert Chart dialog box, click the arrows to scroll through the chart types. Select the type of chart that you want and then click OK.
Which tab on the ribbon do you use to create a chart in Excel?Click the Insert tab, and then click the arrow next to Chart. Click a chart type, and then double-click the chart you want to add. When you insert a chart into Word or PowerPoint, an Excel worksheet opens that contains a table of sample data.
Which ribbon would you go to insert a graph or chart in Excel?To insert a chart, select the data you wish to appear in the chart, and then go to the Insert ribbon (if the data is noncontiguous, you can select one set, and hold down the Control key on the keyboard to select the second set). In the Charts group, choose the desired type of chart.
Which chart tools appear on the ribbon?Chart tools comprise of two tabs DESIGN and FORMAT. Step 1 − When you click on a chart, CHART TOOLS comprising of DESIGN and FORMAT tabs appear on the Ribbon.
|