Curso Excel de Google (Sheets) - Capitulo 2, Gráficos Estadísticos

How to Insert Graphs in Google Sheets

Introduction to Graph Insertion

• The speaker introduces the topic of inserting graphs in Google Sheets, emphasizing its simplicity and accessibility for all users.

• Users can insert a graph by selecting data and clicking on the "Insert Chart" button or through the menu option.

Understanding Data Ranges

• The importance of correctly defining the data range for graphs is highlighted; missing or incorrect data can lead to inaccurate representations.

• Users can modify their selected data range easily, allowing them to focus on specific categories like transportation, services, and health.

Customizing Graph Types

• The speaker explains how users can switch between different types of graphs (e.g., from pie charts to bar charts).

• Customization options are available in the right panel for visual representation, including displaying values and percentages on pie charts.

Editing Graph Features

• If the customization panel does not appear, users can access it by clicking on "Edit Chart" or double-clicking the chart itself.

• Users have control over various aspects such as colors, spacing, and titles within their graphs.

Creating Comparative Graphs

• A more complex graph type is introduced that allows for comparisons between different datasets rather than just displaying single values.

• Users learn how to create an empty chart first before populating it with desired data ranges for income and expenses.

Manual vs. Automatic Graph Creation

• The speaker demonstrates both manual creation of graphs and using automatic features by selecting all relevant data at once.

• Emphasis is placed on understanding manual adjustments while also utilizing automated tools for efficiency.

Final Touches on Data Labels

How to Customize Graphs in Excel

Creating and Modifying Graphs

• Users can create a dedicated sheet for important graphs by selecting the option to move the graph to its own sheet, enhancing visibility and organization.

• To revert changes, users can copy the graph back to the original sheet and modify it as needed, such as removing data labels or adding trend lines.

• Visual adjustments can be made by deleting unnecessary sheets and customizing gridlines for better clarity of data representation.

Customizing Data Presentation

• Users can adjust primary axis settings, centering values around 500,000 instead of one million for clearer data interpretation.

• The type of graph can be changed based on preference; area graphs are highlighted for their ability to show trends effectively over time.

Analyzing Financial Trends

• Area graphs allow users to visualize financial performance over time, indicating periods of high or low spending easily.

• Hybrid charts combining bar and line formats provide comparative insights into budgets versus actual expenses.

Understanding Employee Earnings through Graphical Representation

Calculating Earnings

• A simple table is created to calculate daily earnings based on basic salary divided by 30 days, allowing easy tracking of employee income.

• The formula used calculates total earnings based on days worked; this straightforward approach aids in understanding payroll distribution among employees.

Visualizing Payroll Data

• The initial graph may not effectively represent the relationship between days worked and salaries due to scale differences; adjustments are necessary for clarity.

Graphing Salary Data in Excel

Understanding Basic vs. Total Salary

• The speaker discusses a comparative graph showing the basic salary versus the actual amount received by employees based on their working days.

• Emphasizes the need to focus solely on total salary rather than basic salary, indicating that the data pertains specifically to January.

Combining Data from Multiple Sheets

• A scenario is presented where a manager requests a comparison of payments made in January and February, prompting questions about combining values from two sheets.

• The process for creating a combined graph is explained, highlighting the importance of selecting data intervals correctly.

Selecting Relevant Data for Graphing

• The speaker raises a question about duplicating employee names when only total salaries are needed, suggesting clarity in data selection.

• Discusses potential requests from management to compare both total salaries and working days, emphasizing flexibility in data presentation.

Modifying Graph Series

• Instructions are given on how to modify series within graphs to include various metrics like total salary and working days.

• Demonstrates how to visually differentiate between months (January vs. February) using color coding in graphs.

Methods for Creating Graphs

• Three different methods for inserting graphs are outlined: selecting all relevant data at once, choosing specific columns while holding down control, or starting with an empty graph and adding intervals manually.

• Reinforces that regardless of the method used, what matters is effectively presenting the information required by management.

Practical Application and Homework Assignment

• The speaker assigns homework involving creating five graphs based on provided data as practice for real-world applications.

• Encourages viewers to attempt tasks independently before checking solutions through supplementary videos provided later.

Conclusion and Call to Action