Bars, Lines, Pies and Column Charts
Excel can be complicated, frustrating, exciting, and sophisticated at the same time. Section 5.8 of chapter 5 was fun and educational for me. Learning how to create and modify charts is essential for businesses. Charts in essence, give life to data that otherwise can be confusing on a plain spreadsheet. In other words, charts provide visual representation of information making it easier to understand.
Charts are easily customizable, moveable, and re-sizeable. The tabs in Excel make it so easy to manage data and charts. They can be used to interpret many types of information such as sales, statistics, comparisons, analytics, gains and losses. I mean literally the use of charts is endless.
Most people are less comfortable when looking at a large amount of numbers, visual charts help mitigate that and invite the audience in :-)
ReplyDeleteMicrosoft Excel does make creating and modifying charts easy!
Choosing the most appropriate type of chart for a given scenario requires some thinking instead of just choosing the most visually pleasing type. One of my later in-class presentation/demonstration will cover this ^_^
I just finished 5.8 it was great to know how to work with charts. Now my work should look more professional.
ReplyDeleteLook forward to that section. I am getting close to it. Sounds fun.
ReplyDeleteThis was also my favorite section in chapter 5. I enjoy how the data we have can be converted into any type of graph.
ReplyDeleteI am only a few sections into chapter 5, so far it has been enjoyable.
ReplyDeleteLooks like an interesting section. Looking forward to it.
ReplyDeleteGraphs and charts are great for people who just want to see the "big picture". They aren't so worried about the details, like all the numbers you needed to input to get to the total on the graph/chart.
ReplyDeleteVery interesting chapter on Excel was the charts
ReplyDeleteI am not there yet but I am curious to see more about charts since I currently do not use them.
ReplyDeleteThe purpose of a chart is to visualize the data, that is, to represent the boring data with shapes, colors, and even images, to highlight the data's most important characteristics and conclusions.
ReplyDeleteI look forward to working with different type of charts in Excel when I go through LabSim!
ReplyDeleteTrue I look forward to diving deep into Excel.
ReplyDeleteI do not use charts but thank you for sharing about them! I hope to get into them soon.
ReplyDeleteI completely agree, and I truly appreciate how quickly Excel can generate a chart using the data one provides. It also updates as you enter new data or modify existing numbers.
ReplyDeleteI've always seen so many interesting charts and graphs, it's very cool to learn how to make them myself!
ReplyDelete