Excel Charts - three methods for filtering Chart Data скачать в хорошем качестве

Excel Charts - three methods for filtering Chart Data

Filtering data in Excel charts is easy to do. The method you use should be based on the amount of data you have. In this video, I show three methods of filtering chart data. Method 1 is using Chart Filters. This is the easiest method. Method 2 is using Filters and creating a chart. Method 3 is using a Table and Filters. Methods 2 and 3 work great with large data sets. Method 1 is great for a small set of data. I also show Transpose data and how to keep a chart from moving or disappearing when you filter your data. Chapters ***** 0:00 Intro 0:45 Create a chart 1:00 Chart Filters 1:40 Issue with Chart Filters 2:20 Transpose data 2:51 Filtering Data for charts 4:05 Issue with filter data/charts 4:24 Keep chart showing 6:00 Create a Table 7:15 Data picks up automatically Keep chart from moving and resizing *** Right-click in the chart Format Chart Click Size and Properties Expend Properties Check Don't move or size with cells Close the task pane. #msexcel #microsoftexcel #excelcharts #chrismenard #chrismenardexcel #chrismenardtraining Chris Menard's website: https://chrismenardtraining.com And make sure you subscribe to my channel! - EQUIPMENT USED -------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 - SOFTWARE USED -------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!