Excel with Charts - Part 1
What is Excel?
- Excel ** is a spreadsheet program, ** Microsoft ** has included it in the software suite ** Microsoft Office.
- Microsoft designed Excel as a tool to help record, present processing information in the form of tables, perform calculations,
and build statistics — visually included in the table. Like the Lotus 1-2-3 spreadsheet program, Quattro Pro, etc. Excel 's spreadsheet also
includes many cells which created by rows and columns, data entry and calculation formulas in Excel.
- However, Excel has many advanced features and has a very user-friendly interface. The power of Excel is also very much integrated into the search and analysis tools by programmers. Especially, mention the Excel 's mechanisms that related to Facebook is a must. With the continuous growth of Facebook as well as advertising, the filtering of lists based on criteria and exporting to Excel files is a lot of people 's interest. Not only that, but many programmers also consider ** Excel** as a must-have tool. And for any other software that exports any file for evaluation, Excel is the first choice because of the efficiency it offers.
The history of Excel
The beginning of Microsoft Excel
- Previously, Microsoft introduced a spreadsheet software called Multiplan in 1982, which was very popular on CP / M operating systems,
but on MS-DOS, it was no longer so. That spurred the development of a new spreadsheet program called Excel.
- Microsoft release the first version of Excel on the MAC in 1985, and on Windows (numbered 2.0 is on par with the MAC and
integrated with the Windows run-time environment) in November 1987. Lotus was too slow to release 1-2-3 for Windows, and until the end
of 1988, Excel began selling more than 1-2-3 and helped Microsoft achieve its position as a leading software developer.
- On average, Microsoft releases a new version of Excel every two years or so. The most recent version is Excel 2019.
Excel with copyright
- Recently, Excel has become the target of a lawsuit. The reason is that another company has sold a software package that has taken the name
"excel" in the financial industry before. The result of the controversy over the need to collate all legal documents and records of "Microsoft Excel" software.
- However, when dealing with this case, people ignored it, and Microsoft always handled the problem when they bought trademarks of other programs.
- Microsoft also encouraged users to use the XL character as a shorthand for the program. While debating the name of the program, its icon is still the default green X, and the Excel extension is .xls.
Excel with Graph
- Excel provides users with quite a lot of work interfaces. However, they are mostly the same. Excel is the first program that allows users to
change the font, font style, or shape of the spreadsheet, and also suggests giving users more intelligent ways to handle problems.
Especially, Excel has excellent graph ability.
Excel with VBA
- Since 1993, Excel has included Visual Basic for Applications (VBA for short), which is a programming language based on Visual Basic. Microsoft has added it to automate jobs in Excel and allow users to create custom functions.
- VBA is a powerful program language; in recent versions, Microsoft has included it to integrated development environments (IDEs).
The function to record macros can create VBA code for repetitive actions of users, allow everyday operations to be automated,
VBA also allows creating tables and modifications. Language support (but not creation), ActiveX DLL (COM), later versions added
support for modules, allowing the use of necessary object-oriented programming technologies.
- The automated functions created by VBA have made Excel an object for macro viruses. There was a severe bug in Office until antivirus software manufacturers started to detect them. Microsoft has taken measures to prevent misuse by adding options: Completely remove macros, enable macros when opening a workbook, or trust macros that are recognized by a trusted source.
Excel with Graphs
When you are ready to create charts for your data in Excel, this article can help you know a bit more about each chart type. You will learn how to arrange data for the desired chart type or chart style that fits your data.
- A bar chart can represent data arranged in columns or rows on a spreadsheet. Column charts often depict categories by the horizontal axis and vertical values.
Types of column charts
- Clusted column chart: Shows values in the 2-D column form. Use this chart when you meet the following categories:
- Value ranges (for example, item numbers).
- Specific scale levels (for example, the Likert scale has entries such as complete agree, agree, neutral, disagree, strongly disagree).
- Names are not in any particular order (for example, item names, geographical names, or people names).
- Stacked columns chart: The stacked column chart represents values in the form of 2-D stacked columns. Use this when you have multiple data series, and you want to emphasize totals.
- 100% Stacked Columns: The 100% stacked column chart shows values in the form of 2-D columns stacked to represent 100%. Use this when you have two or more data series, and you want to emphasize the level of contribution to the total, especially if the total for each category is the same.
- A line chart can represent data arranged in columns or rows on a spreadsheet. In a Line Chart, the distribution is even between catalog data along the horizontal axis and all value data along the vertical axis. Line charts can represent time-series continuous data on a uniformly graded axis and are therefore ideally suited to serve data trends at equal intervals such as months, quarters, or years.
Types of line charts
- Marked roads and roads: Marked with or without marks to indicate individual data values, line charts can show trends over time or categories, evenly spaced, especially when you have them. Many data points and the sequences that represent them are essential. If some multiple types or values are only approximate, use a line chart without a mark.
- Stacked lines and marked lines: Stacked with or without markers to indicate individual data values, stacked line graphs can show the trend of the contribution of each value over time.
- 100% Stacked Lines and 100% Stacked Lines with Marked: Marked with or without Marking to indicate individual data values, 100% stacked line charts may show a percentage closing trend. Spaces are equal between the contributions of each value over time or categories. If there are multiple categories or relative importance, use a 100% stacked line chart without markup.
- A Pie charts can represent data arranged in a column or a row on the worksheet. Pie charts depict the size of items in a data series, proportional to the total number of items.
We may express the data points in the pie chart as a percentage of the whole circle. Consider using a pie chart when:
- You only have one data series.
- No values in your data are negative.
- You do not have more than seven categories, and all of these represent a partial value of the whole circle.
- Bar Chart can represent data arranged in columns or rows on spreadsheets. The Bar Chart illustrates the comparative relationship between individual items. In Bar Chart, it usually organizes those categories along the vertical axis and values along the horizontal axis.
- Consider using a bar chart when:
- The axis labels are too long.
- You wish to express the values as time intervals.
Types of bar charts Interlocking
- The cluster diagram: shows bars in 2-D format.
- Stacked bar: The stacked bar graph shows the relationship of individual items to the whole as a 2-D bar
- 100% Overlay: The 100% stacked bar chart shows 2-D bars to compare the percentage of each value in the total across categories.
- An Area Charts can represent data arranged in columns or rows on a spreadsheet. We can use Area Charts to show change over time and direct attention to the total value across a trend. By expressing the full amount, an area chart also shows the relationship of the parts to the population.
Types of area charts
- Regions: Shown in 2-D format, the area chart shows trends in values over time or other category data. Typically, line charts should be used instead of non-stacked area charts, because we may hide data in one string behind the data of other strings.
- Stacked Area: The stacked area graph shows the trend of the contribution of each value over time or other category data in the 2-D format.
- 100% Overlays: 100% stacked area graphs show the percentage bias that each value contributes over time or other category data.
- Data arranged in columns or rows on spreadsheets can be represented by scatter plots. Place the x values in the row or column, then enter corresponding y values in adjacent rows or columns. A scatter chart has two value axes: the horizontal value axis (x) and vertical (y). It combines axis (x) and vertical (y)values into single data points and displays them in irregular intervals or clusters. It is a suggestion to use Scatter Charts to represent and compare numerical values such as scientific, statistical, and technical data.
- Consider using scatter charts when:
- You want to set that axis in logarithmic proportions.
- The values of the horizontal axis are irregularly spaced.
- There are multiple data points on the horizontal axis.
- You want to adjust the independent axis of the scatter chart to provide more information about the data that contains the pair or value group.
- You wish to denote similarities between large data sets instead of differences between data points.
- You want to compare multiple data points that don't involve time - the more the data is included in the scatter chart, the better you can make comparisons.
Types of scatter charts
- Scattering: This graph shows data points without concatenating lines to compare value pairs.
- Scatter with smooth lines and mark and scatter with sleek lines: This graph shows soft curves connecting data points. We may indicate sleek lines may with or without marking. Use sleek lines without marking if there are multiple data points.
- Scatter with straight lines and mark and scatter with straight lines: This graph shows consecutive lines between data points. We may indicate the ranges with or without markup.