Adjust Chart Record For Free

A chart is automatically updated once data is edited. The table can be opened as a regular table or as an Excel table allowing access to the tools in Excel. Another way to edit the data is by selecting the chart, right click with a mouse, and select Edit Data in the menu.

Select the Excel chart (single click) and then right click to choose Copy. Move to a different location in the same worksheet or add a new worksheet and then right click and choose Paste. This gives you an exact copy of the chart so it is linked to the original data range and has the same formatting.

Edit data included in a chartClick the chart.On the Charts tab, under Data, click the arrow next to Edit, and then click Edit Data in Excel.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.More items...

Choose the Home ribbon menu and open the form in Design View. Now on the Design ribbon you will see a small Chart icon (shown in Figure 3). Click on the icon, go to your blank form and make a reasonably sized square by holding down the mouse button and then letting go.

Change the chart type of an existing chartDo one of the following:On the Design tab, in the Type group, click Change Chart Type.In the Change Chart Type dialog box, click a chart type that you want to use.

Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK. Changes you make may break links to the source data on the worksheet.

Modify the chart To modify a chart, open the form or report in Design or Layout view, and then select the chart which opens the Chart Settings pane. To switch to a different chart type, select a different chart from the Chart Type property drop-down list.