SA10 YOUR NAME ib_e05_chartchaos.xlsx

SA10 YOUR NAME ib_e05_chartchaos.xlsx - Compare this to...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
2006 2007 2008 2009 0 5,000 10,000 15,000 20,000 25,000 30,000 35,000 40,000 45,000 50,000 50000 40000 30000 20000 35000 30000 30000 25000 25000 30000 30000 40000 20000 30000 40000 50000 Product Category Trends Suits Dress Pants Casual Pants Casual Knits Unit Sales
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Sales Data for Product Lines Units Sales Product 2006 2007 2008 2009 Suits 50,000 40,000 30,000 20,000 Dress Pants 35,000 30,000 30,000 25,000 Casual Pants 25,000 30,000 30,000 40,000 Casual Knits 20,000 30,000 40,000 50,000
Background image of page 2
# Questions 1 2 3 Did the Casual Knits bar in the year 2007 really disappear? Can an individual bar be formatted on a column chart? Why are some of the bars cut off at the top of the chart? Look at the worksheet named Sales Data. What is the highest unit sales value?
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Compare this to the highest sales value along the Y-axis. How could the values or scale for the Y-axis change? In the years 2007 and 2008, several data labels merged together. Can an individual data label be formatted or moved? Answers No it did not disappear it had been formatted incorrectly and is now purple By formatting the axis you can change the maximum to the max units to show all data By formatting the labels you can change the alignment so that all of the labels do not run together....
View Full Document

This note was uploaded on 08/11/2011 for the course CTS 130 taught by Professor Walters during the Spring '11 term at Fayetteville Technical CC.

Page1 / 4

SA10 YOUR NAME ib_e05_chartchaos.xlsx - Compare this to...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online