Total Profits per Region
A column chart is the most fitting graph for the first worksheet – total profits per region. According to Alexander (2016), a column chart is an appropriate option when the user needs to compare one characteristic among several categories. In the current case, the individual variable is total profit, which varies depending on the region. Hence, I would choose a column chart because it is simple and transparently shows the difference between the categories based on the data. Figure 1 below demonstrates the total earnings depending on the area.
Moreover, it is possible to modify the graph to make it more illustrative. Changing the colors, sorting the regions by the profits, and other operations might enhance the visual aspect of the chart. Ultimately, a column chart is an appropriate choice for the first worksheet.
Sales per Month
The second worksheet – sales per month – is a more complicated dataset with several variables. The chart needs to represent the difference in sales per rep during four months, including the total sum. According to Alexander (2016), a clustered column chart and a combination chart are appropriate options. Both choices compare data among several categories and for multiple variables (Alexander, 2016). However, considering the Total cell, it might be more illustrative to use a combination chart. It will demonstrate the differences between the reps and their respective sales while also showing the total number of earnings as a line. Figure 2 below presents a combination chart that illustrates all variables and categories of the second worksheet:
As seen in Figure 2, the graph transparently shows the sales per rep each month as a clustered column and the total earnings as a line above. It provides valuable information about the performance of each rep, the profits each month, and the differences between the overall sales during the period.
Reference
Alexander, M. (2016). 10 Excel chart types and when to use them. Dummies. Web.