Charts

Weather Assignment
1.  Chart the city and the temperature as a clustered bar with a 3-D visual effect. 

• Supply an appropriate chart title and axis titles.  (Temp is not the title)
• Remove the legend from the chart. 
• Place the chart as a new sheet named "temperature". 
• Leave the walls/background of the chart white. 
• Change the font size of the chart title to 18 and pick your choice of color. 
• Format the axis titles to a size 14 font and your choice of color. 
• Place the bars in a gradient with two colors of your choice.

2.  Chart the city, temperature, and humidity as a 3-D Clustered Column.   

• Supply an appropriate chart title and axis titles. (Temp and Humidity will not be the axis title) 
• Place the legend at the bottom of the chart. 
• Place the chart as a new sheet named "Temp and Hum". 
• Format the plot area of the chart to a color of your choice. 
• Change the font size of the chart title to 18 and pick your choice of color. 
• Format the axis titles to a size 14 font and your choice of color.  
• The temperature bar should be red. 
• The humidity bar should be blue.

3.  Chart the city, sunrise, and sunset times as a line chart with a marker. 

To begin, highlight ONLY the sunrise and sunset times.  Create the chart, then go back to add the cities.

• Supply an appropriate chart title and axis titles. 
• Place the legend at the bottom of the chart. 
• Place the chart as a new sheet named "Time". 
• Format the chart area of the chart to yellow. 
• Change the font size of the chart title to 18 and pick your choice of color. 
• Format the axis titles to a size 14 font and your choice of color. 
• The AM marker should be a triangle size 8 in your choice of colors. 
• The AM line needs to be formatted to the same color with your choice of line style and weight. 
• The PM marker should be a size 8 in your choice of color and style. 
• The PM line should is formatted to the same color as the marker with your choice of line style and weight.

Back