#Charts excel 2007 tutorial series#

The chart below shows a Data Table.Ĭlick Data Table on the Data Labels section of the Layout tab. Display a Data TableĪ Data Table displays the chart data. To customize, click on the item's border and select 'Format Shape' from the right-click menu. Then click in the chart and draw a box to hold the item. To insert a Text box or Shape, click the desired icon on the Insert section of the Layout tab. Images can be formatted manually via the right-click menu. Resize the image by moving its borders with the cursor.

Select the picture from your hard drive and click Insert.

To insert a picture, click the Picture icon found on the Insert section of the Layout tab. Insert a Picture, Shape, or Text Box on the Chart Optional elements can be added to the chart found on the Layout tab, including images, shapes, text boxes, data tables, or data labels. To return to the original layout, click the last layout on the menu. Click on a layout to see its effect on your chart. To view the layouts, select the chart, click the Design tab, and click the bottom arrow on the right margin of the Chart Layout section. Select a Chart LayoutĮxcel provides Chart Layouts that offer various arrangements of a chart's elements. The style you began with is usually the second style in the top row. To view available styles, select the chart, click the Design tab, and click the bottom arrow on the right side of the Chart Styles section as shown above.Ĭlick on a style to see its effect on your chart. Some styles contain borders or backgrounds. Using your Theme colors, Excel provides nearly 50 Chart Styles that recolor your chart differently. The image below shows the default layout and then the switched layout. If you want to switch the default, select the chart and click the Switch Row/Column icon on the Design tab. Whichever has the most entries is charted on the X-axis (Y-axis for Bar Charts). Switch the Rows and ColumnsĪn Excel chart is drawn from selected rows and columns of data. Choose Chart Tools Design> Chart Styles and click the More button, which displays the Chart Styles gallery.Chart layout and style options are found on the ribbon's Design tab.Select any additional options and then click ok.In the Number option, select a number style for the data labels.

#Charts excel 2007 tutorial series#

If you don't want the data label to be the series value, choose a different option from the Label Options area (such as.The Format Data Labels dialog box appears. Choose Chart Tools Layout> Data Labels> More Data Label Options.See the data labels with a placement of Outside End. A menu of data label placement options appears. Choose Chart Tools Layout> Data Labels.Click anywhere on the chart that you want to modify.Reader needs to see exact values along with a graphical display, such as when using a 3-D chart. Data tables display the chart values in a grid beneath the chart. A data table, displays at the bottom of the chart showing the actual values.ĭata tables can be added to charts on a regular worksheet, but it isn't a common practice because the worksheet itselfĪlready displays the data. Options include a choice not to show a data table, show a data tableīut not show a chart legend, or to show a data table and include the chart legend. Click Chart Tools Layout> Labels> Data Table.

Click anywhere on the chart you want to modify.Make your selections from the various formatting options and click ok.Excelĭisplays the Format Data Table dialog box.

To explore additional formatting options for the data table, choose More Data Table Options from the menu.Click the Data Table button and choose an option from the menu.Click anywhere on the chart and click the Layout tab to display the chart layout tools on the Ribbon.To add a data table to an existing chart, follow these steps: When youĬreate a chart, you can select a layout that includes a data table. In Excel, you can display a table of the data that you use in the chart.