Explore the AutoSum functions with other data fields. How do these calculations impact or inform your understanding of the data? What questions do you have about the data or calculations?

I have no questions, I was having trouble figuring out how to get the sum because I was clicking on the column and then hitting the SUM button, but I figured out that it’s better if you click the SUM button before clicking all the number you want to calculate.

What types of visualizations were you able to generate in Excel using PivotChart? How could those visualizations shape or impact your understanding of the data? Did you generate any visualizations that were confusing or misleading? Alternatively, did you generate any visualizations that were unexpected or illuminating?

I was able to create a bar chart with two specific variables from the data. I was also able to customize my bar char with the colors I wanted and what style of bar graph I wanted. For example if I wanted 2D, 3D, black and neon, one with lines that filled in my bar graph etc. I surprisingly shocked at the amount of options they had to customize the design of the box chart as well as how easy it was to create one. Overall I really like how they had the feature of the different shades you can add to you chart in order to make it more stand out. Other than that I learned a lot and I’m excited to put this new skill into use.

The Before vs. After

   

As you can see with the images above we have a difference on the before making any changes to the chart into personalizing it to my liking. Overall you can see the colors are changed, the width of the bar, the transparency, as well as I added shading to the bars in order to give it a more subtle 3D effect without it being too overwhelming. One last thing I also added was the square of the chart I curved the edges with a blue boarder. Happy with how it turned out.