Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 5 . Elena wants to show the total amount invested compared to the total value during the eight months of investments. Insert a chart

15. Elena wants to show the total amount invested compared to the total value during the eight months of investments.
Insert a chart in the Client Investment Tracker worksheet as follows to show this information:
a. Based on the nonadjacent data in the Date (range A20:A28), Total Value (range C20:C28), and Total Invested (range D20:D28) columns, insert the first type of chart that Excel recommends, which is a Clustered Column Line chart.
b. Move and resize the chart so that its upper-left corner is in cell A5 and its lower-right corner is in cell F19.
c. Remove the chart title because the legend identifies the data clearly.
16. Elena wants to make sure that people reviewing the worksheet understand it displays sample data.
Add a shape to the worksheet as follows to provide this information:
a. In cell E30, insert a Callout: Line shape from the Callouts section of the Shapes gallery.
b. Move the callout line so that it points to the bottom of the "Total Invested" column.
c. Type Sample data only in the callout shape.
d. Apply the Subtle Effect Turquoise, Accent 1 shape style to the callout shape.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional IPhone And IPad Database Application Programming

Authors: Patrick Alessi

1st Edition

0470636173, 978-0470636176

More Books

Students also viewed these Databases questions

Question

Identify the "always bar list" and the "presumption list."

Answered: 1 week ago