Final answer:
To represent the contribution of each lighting product type to total sales per store, Jacob should create a 100% stacked column PivotChart. This chart clearly shows proportional contributions and allows for easy comparison among categories. Readability is enhanced by ensuring legible percentages and distinct color coding.
Step-by-step explanation:
To accurately showcase the percentage each type of lighting product contributes to total sales in each store using a pivot chart, Jacob will need to create a 100% stacked column PivotChart. This type of chart is especially effective because it displays the distribution of categories as segments of 100%, making it easy to compare the proportional contribution of each category. When creating the chart, ensure that the data is properly organized in the PivotTable, with sales figures and product types correctly placed in the axis fields. Then, use the pivot chart tool, typically found in spreadsheet software, to insert a 100% stacked column chart. Following the chart creation, it's important to customize the chart for better readability. This includes making certain that the percentages are legible, categories are ordered to enhance comprehension, and that colors used are clearly distinguishable for each lighting product type.