Use the quick analysis tool in excel to create a clustered column chart
In the 3-D pie chart, change the font size of the title to 14 pt. Then add the Primary Vertical Axis Title Cost toĬhange the major units value for the vertical axis to 250000.0.Ĭhange the style of the Clustered Column Chart to Style 7 (7th choice in Rather than touching the edges of those cells.)Ĭhange the chart title of the Clustered Column Chart to Rental Cost Sure the corners of the chart are completely within the cells A10 and G27 Move and resize the chart so that the top left corner is in cell A10 and theīottom right corner is in cell G27. (Note: The columns in this chart are grouped by year.) Use the Quick Analysis tool on the range A3:F7 to insert a ClusteredĬolumn chart, using the first Clustered Column Chart recommendation on Sparklines to Sparkline Style Colorful #4. On the Rental Cost Projection worksheet, create column sparklines in the Add data labels to the chart and change the label options so that theĬhange the location of the data labels in the 3-D pie chart using the Change the location of the chart legend to Top.ī. In the 3-D Pie chart, make the following adjustmentsĪ. In the 3-D Pie Chart, modify the legend labels to use the label text from This chart is completely within cell H10, rather than touching the edge of (Hint: To ensure proper grading, make sure the corner of Share of Rental Cost and then move the chart so that the top left corner Change the major units value for the vertical axis to 250000.0Īdd Primary Major Vertical Gridlines to the chart.Ĭhange the position of the Clustered Column Chart’s legend using theĬreate a 3-D Pie Chart based on the range I4:I7. Change the number format of the vertical axis to Accounting with 0ī. In the Clustered Column Chart, make the following adjustments to theĪ.
![use the quick analysis tool in excel to create a clustered column chart use the quick analysis tool in excel to create a clustered column chart](http://www.learningcomputer.com/blog/wp-content/uploads/2015/11/excel_insert_tab3a.jpg)
Change the style of the sparklines to Sparkline StyleĪdd the chart title Yearly Rental Costs 2011-2016 to the Clustered ColumnĬhart using the Above Chart title option.Īdd the primary vertical axis title Cost to the Clustered Column Chart. Range I4:I7 (1st column, 1st row in the Gradient Fill section of the DataĬreate column sparklines in the range H4:H8 based on the data in the On the Rental Cost History worksheet, add blue gradient data bars to the New Perspectives Excel 2013 Tutorial 4: SAM Project 1aġ New Perspectives Excel 2013 Tutorial 4: SAM Project 1a