Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started