Feb 23 2018

Choosing and Selecting the Source Data for an Excel Chart


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:

  1. On the Insert tab, select the chart type you want.
  2. On the Chart Design tab, select Select Data.
  3. 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.



Random Posts

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 



Subscribe Form

Subscribe to Blog

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks