Sample data showing units sold and total transactions. To ensure you can follow along, we’ve created a simple data set below: Then we’ll show you how to add some finishing touches to make your chart look polished and professional. We’ll walk you through the two major steps- combining different chart types and adding a secondary axis. I’d much rather create a single chart that incorporates both data sets such as the one shown below.Ĭhart showing both units sold and total transactions.ĭaunting though it may seem, it turns out that making this kind of chart isn’t very difficult at all. However, it will be challenging to analyze and compare the two charts separately. I could make two different charts-one plotting units sold per month, and another plotting total transaction revenue by month. I’m hoping to identify trouble spots, such as high unit sales that result in low revenue, which may in turn indicate that the units are being sold too cheaply. Suppose I work at a manufacturing company, and I’d like to analyze the number of units we’ve sold over the last few months and the total revenue generated. So far, Forms seems to be focused on showy presentation and frippery for novices instead of truly useful connections for the millions of Office users around the world.Turn data into insights. We could go on about Forms many limitations. Our book Real Time Excel shows how it’s done in the chapter on Historical Stock Prices. There is a workaround for this, if the user knows how to import data from a special folder with a changing file name. Forms changes the XLSX file name each time (with the number of responses). Why can’t Forms use one of those to let Excel directly import the latest results without manually downloading a file?Ĭonsistent File name PowerQuery can be setup to import the latest version of a source file, but only with the same file name. Just a few things you’d expect from a proper integration of a Microsoft product with Microsoft Excel and PowerQuery.ĭirect data link Modern Excel has many direct data sources available including seven different types from Microsoft Azure alone. It’s almost as if the Forms and Excel developers haven’t worked together, even though they work for the same company! The integration between Microsoft Forms and Excel is very poor.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |