As we have indicated on numerous occasions, Excel is one of the star programs with great versatility to offer you all kinds of services oriented to present budgets , capture statistical data, reflect inventories, generate calendars and agendas , distribute tasks among the members of a team, calculate financing plans, make invoices and even plan your retirement .
Within a spreadsheet, including Advanced graphics such as dynamic tables can be very useful to expand the information, and can be generated by means of macros or manually. Some examples are the circular ones, the grouped horizontal cones, the 3D pyramids or the stacked bars, that you can consult in specialized web pages like Excel Advanced . We tell you what are some of the main steps you must take into account when creating them.
5 keys to create advanced graphics in Excel
- Check and highlight your data : As always you must do, it is essential to take a quick look to see if there are any problems or flagrant errors in your data set that you will capture visually. Therefore, check the spelling, digits or any other problem that involves an annoying subsequent correction.
- Reflect previously on the type of graph you want to use : Each of them is a different way of representing the data. For example, in the columns and other variants such as bar or area relate two axes, line relate two different concepts that are usually about magnitudes, circular-also called cake-usually represent proportionality with respect to a total while those of dispersion and dispersion contribute in the identification of the relationship that may or may not exist between two concepts
- Select the data set and click on the “Insert” menu . Then choose the option “Graphics” and select the one you want to use. For example, you could use a column chart to represent the total number of email subscribers your newsletter has.
- Confirm the data range and click Next . Next, write a title for your graphic and click Next again to finish clicking on Finish. In this way the advanced graphic will be inserted in the spreadsheet. Then, do not forget to click on File and Save to confirm the changes made.
- Perfect your presentation : You can adjust the colors afterwards, add a title, add labels or refine any aspect you consider interesting. Learn to play with the different types of advanced graph according to your needs and the type of data that you are going to represent in the spreadsheet.
