Choose Chart Record For Free

How to get a graph to only plot certain data that meet a specific... Click Insert>pivotable>select your data range by dragging.Now you insert a pivot table to your new sheet, you can rename it.You can see a PivotTable Fields at right of the work sheet.

Creating a chart Select the worksheet you want to work with.Select the cells you want to chart, including the column titles and row labels. Click the Insert tab. Hover over each Chart option in the Charts group to learn more about it. Select one of the Chart options.Select a type of chart from the list that appears.

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.

If you want to compare values, use a pie chart for relative comparison or bar charts for precise comparison. If you want to compare volumes, use an area chart or a bubble chart. If you want to show trends and patterns in your data, use a line chart, bar chart, or scatter plot.

To do this, first select the pie chart from the Insert > Charts menu to select one of the pie chart options. This will create an empty pie chart object on the sheet. Next, select Chart Tools > Design > Select Data (Data group). This opens the Select Data Source dialogue box.

Use a bar or column chart to compare independent values. We, as readers, are particularly good at comparing the length of bars in a bar chart (in contrast to the segments of a pie chart, for example), making bar and column charts the best charts for showing comparisons.

Bar charts are good for comparisons, while line charts work better for trends. Scatter plot charts are good for relationships and distributions, but pie charts should be used only for simple compositions never for comparisons or distributions.