Choosing and Selecting the Source Data for an Excel Chart
- 0 Comments
Excel Hints: Choosing and Selecting the Source Data for an Excel Workbook
So you have an Excel workbook loaded with some sales data for your company and you want to create a chart so that you can see the trend. Sounds easy? It is that easy, just two keys on the keyboard is all that it takes.
Method One – Select a cell in the data table, then press “Alt & F1” keys to create a chart instantly
Method Two:
- On the Insert tab, select the chart type you want.
- On the Chart Design tab, select Select Data.
- Click in the Chart data range box, and then select the data in your worksheet.
Did you know?Did You Know? If a value changes in the chart’s data source, that change is automatically updated in the chart!
Microsoft says, “Tip: If you don’t want to include specific rows or columns of data in a chart, you can simply hide them on the worksheet, or you can apply chart filters to show the data points you want after you create the chart.”
Microsoft explains:, how to select data for a chart.
It really is that easy. And it is just as easy to change they way they look and function. Well that ends this Excel Hint. Here is a link to our page with free online Excel and Access training videos.