![]() ![]() In order to make a pie chart, you must have a list of categorical variables(descriptions of your categories) as well as numeric variables. You could read that New Yorkers (perhaps surprisingly) throw a lot of recyclables into their trash, but a pie graph gives a clear picture of the large percentage of recyclables that find their way into the trash. The following chart shows what New Yorkers throw in their trash cans. Pie charts give you a snapshot of how a group is broken down into smaller pieces. You can see that toilet water usage is greater than shower water usage because the piece of the “pie” is greater: Try it with different data and various chart styles and see how it comes out.The following chart shows water usage (image courtesy of the EPA). ![]() So now, every time I filter my table, the chart will dynamically adjust to that data: I chose columns A and C:F for my chart and used Alt + F1: The simplest way to create a basic chart in Excel is to highlight the data that you want included in your chart and use either of the following keyboard shortcuts:Īlt + F1 – if you want the chart on the same worksheetį11 – if you want the chart on a new worksheet Next, I want to create a chart from my data. One of the benefits of using tables is the automatic inclusion of filters. Click OK and now I have a proper table in Excel: A dialog box will appear with my range defined and a check box in "My table has headers". To do so, all I need do is click anywhere in my data range and use the keyboard shortcut Ctrl + T. You can view my post on the benefits of Tables here. There are many benefits of using tables rather than data ranges. The first think that I want to do is convert my data range into an Excel Table. ![]() I want to create a chart and have it automatically modify as I filter my data. ![]() Here I have a simple, properly structured data range: If you see a preview, look for the download button in the upper right hand corner. You can download the file here to follow along. Did you know that your charts will dynamically adjust as you filter the underlying data? Let's see how: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |