Question: 1 7 . In Budget Comparison worksheet, select data range B 8 :D 1 2 , then insert a 2 D Clustered Column chart. Move
In Budget Comparison worksheet, select data range B:D then insert a D Clustered
Column chart. Move and resize the embedded column chart to cover the range A:I in Charts
worksheet Note: position no need to be exactly, relevant location and size would be fine
Add a chart title Family Budget Comparison to above column chart and set its font size to
points.
Change the legend from Series Series to Year and Year respectively.
Note: its okay if you cant find this function in Google Docs
In Family budget worksheet, select data range B:C insert a D pie chart. Add a
chart title Expenses to it and set chart title font size to points. Add data label to this
pie chart, move and resize the embedded pie chart to cover the range A:I in Charts
worksheet, see the resulting charts Figure
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
