Remove the unwanted fields – keep only Investment and Amount fields. All the data will be displayed on this Power View sheet. This sheet is just a white rectangle with a field list on the right side. If you do have Excel 2013 professional and you still do not see Power View tab, read this article for further instructions.Ī new sheet will be added. Click inside the data and choose Insert tab – Power View. Before you say “I don’t need this new thing”, have a look. Why? Because Excel 2013 (Pro Plus) gives you a new way of analyzing data called Power View. This time we are NOT going to use a Pivot Table. We want one pie chart for each month – to see how customers invested their money. The type of investment could be Bank Deposit, Real Estate or Equity. ![]() Each row represents a transaction where a customer invested some money in some type of instrument.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |