If you already have your data in another table, you can copy the data from that table and then paste it over the sample data.
See the following table for guidelines for how to arrange the data to fit your chart type. For this chart type. In columns, putting x values in the first column and corresponding y values and bubble size values in adjacent columns, as in the following examples:.
In columns or rows in the following order, using names or dates as labels, as in the following examples:. In columns, putting x values in the first column and corresponding y values in adjacent columns, as in the following examples:. To change the number of rows and columns included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data. In the following example, the table is expanded to include additional categories and data series.
Note: When you close the Word document or the PowerPoint presentation that contains the chart, the chart's Excel data table closes automatically. After you create a chart, you might want to change the way that table rows and columns are plotted in the chart. For example, your first version of a chart might plot the rows of data from the table on the chart's vertical value axis, and the columns of data on the horizontal category axis.
In the following example, the chart emphasizes sales by instrument. However, if you want the chart to emphasize the sales by month, you can reverse the way the chart is plotted. You can also edit the data by clicking the chart, and then editing the worksheet in Excel. Click the Chart Design tab, and then click Quick Layout. Chart styles are a set of complementary colors and effects that you can apply to your chart.
When you select a chart style, your changes affect the whole chart. To see more styles, point to a style, and then click. Click Chart Title to choose title format options, and then return to the chart to type a title in the Chart Title box.
Update the data in an existing chart. Chart types. On the Charts tab, under Insert Chart , click a chart type, and then click the one that you want to add. When you insert a chart into Word or PowerPoint, an Excel sheet opens that contains a table of sample data. See the following table for guidelines on how to arrange the data to fit your chart type.
To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data. On the Charts tab, under Data , click Plot series by row or Plot series by column. If Switch Plot is not available. Switch Plot is available only when the chart's Excel data table is open and only for certain chart types. On the Charts tab, under Chart Quick Layouts , click the layout that you want.
To see more layouts, point to a layout, and then click. On the Charts tab, under Chart Styles , click the style that you want. Under Labels , click Chart Title , and then click the one that you want. Available chart types in Office. You can create a chart for your data in Excel for the web. Depending on the data you have, you can create a column, line, pie, bar, area, scatter, or radar chart. On the menu that opens, select the option you want.
Hover over a chart to learn more about it. Tip: Your choice isn't applied until you pick an option from a Charts command menu. Consider reviewing several chart types: as you point to menu items, summaries appear next to them to help you decide. To edit the chart titles, legends, data labels , select the Chart tab and then select Format.
In the Chart pane, adjust the setting as needed. You can customize settings for the chart's title, legend, axis titles, series titles, and more. It's a good idea to review your data and decide what type of chart would work best. The available types are listed below. A column chart typically displays categories along the horizontal axis and values along the vertical axis, like shown in this chart:. Clustered column A clustered column chart shows values in 2-D columns. Use this chart when you have categories that represent:.
Specific scale arrangements for example, a Likert scale with entries, like strongly agree, agree, neutral, disagree, strongly disagree. Names that are not in any specific order for example, item names, geographic names, or the names of people. Stacked column A stacked column chart shows values in 2-D stacked columns. Use this chart when you have multiple data series and you want to emphasize the total.
Use this chart when you have two or more data series and you want to emphasize the contributions to the whole, especially if the total is the same for each category. Data that is arranged in columns or rows on a worksheet can be plotted in a line chart.
In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis. Line charts can show continuous data over time on an evenly scaled axis, and are therefore ideal for showing trends in data at equal intervals, like months, quarters, or fiscal years.
Line and line with markers Shown with or without markers to indicate individual data values, line charts can show trends over time or evenly spaced categories, especially when you have many data points and the order in which they are presented is important. If there are many categories or the values are approximate, use a line chart without markers.
Stacked line and stacked line with markers Shown with or without markers to indicate individual data values, stacked line charts can show the trend of the contribution of each value over time or evenly spaced categories. Line charts work best when you have multiple data series in your chart—if you only have one data series, consider using a scatter chart instead. Stacked line charts add the data, which might not be the result you want.
It might not be easy to see that the lines are stacked, so consider using a different line chart type or a stacked area chart instead. Data that is arranged in one column or row on a worksheet can be plotted in a pie chart. Pie charts show the size of items in one data series, proportional to the sum of the items.
If you need the increased capabilities of Excel to create a chart or graph, and then put it in a Microsoft Word document, follow the steps below. Using the process above, you cannot modify the chart or graph through Microsoft Word after placing it in the document. Create chart or graph directly in Microsoft Word. Create chart or graph in Microsoft Excel and copy to Microsoft Word. Note Using the process above, you cannot modify the chart or graph through Microsoft Word after placing it in the document.
Don't see the chart that you want in this article? For more information about the variety of graphs and charts you can use, see Available chart types. Want to create an organization chart? For more information about how to create organization charts, see Create an organization chart. If Microsoft Excel isn't installed on your computer, you will not be able to take advantage of the advanced data charting capabilities in the Microsoft Office Instead, when you create a new data chart in Word , Microsoft Graph opens.
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. Tip: For more information on chart types, see Available chart types.
To get a good idea of what you can add to or change in your chart, under Chart Tools , click the Design , Layout , and Format tabs, and then explore the groups and options that are provided on each tab.
Note: If you don't see the Chart Tools , make sure that you click anywhere inside the chart to activate it. You can also access design, layout, and formatting features that are available for specific chart elements such as chart axes or the legend by right-clicking those chart elements.
To learn about the available chart types , see Available chart types. To edit data in your chart , see Change the data in an existing chart. Present data in a chart. Click the chart type and then double-click the chart you want. Notes: Don't see the chart that you want in this article? Need more help? Expand your skills.
0コメント