The table below provides monthly revenue values for Tedstar, Inc., a company tha

Question

The table below provides monthly revenue values for Tedstar, Inc., a company that sells valves to large industrial firms. The monthly revenue data have been graphed using a line chart in the figure below.

Data:

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Revenue ($)

145869

123576

143298

178505

186850

192850

134500

145286

154285

148523

139600

148235

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Revenue ($)

145869

123576

143298

178505

186850

192850

134500

145286

154285

148523

139600

148235

Explanation / Answer

(a) What are the problems with the layout and display of this line chart?

Ans: In this line chart the y Axis is not displaying properly

       In this cahrt not displaying axes titles

     Background colour is simillar to the chart colour which could have been different

(b) Create a new line chart in Excel for the monthly revenue data at Tedstar, Inc. Format the chart to make it easy to read and easy to interpret the data. Choose the correct line chart below.

Ans: Chart (iii) is easy to read and easy to interpret the data

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.