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

 

choosing-and-selecting-the-excel-chart-data-source-image

 

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.

 

choosing-data

 
 

Did you know?Did You Know? If a value changes in the chart’s data source, that change is automatically updated in the chart!

 
 

excel-data-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: 

          
TAGS:

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives