Curso Excel 2010 Básico. Vídeo 21. Gráficos II

How to Create and Modify Graphs in Excel 2010

Introduction to Graphs

• The video is part of a basic Excel 2010 course focusing on graphs, continuing from previous lessons.

• Previous content covered creating simple graphs from tables and modifying key features like titles, legends, and axis names.

Advanced Graphing Techniques

• This session will explore how to represent different data series with various graph types (e.g., columns, lines).

• The instructor highlights the common practice of using mixed chart types for better data representation.

Creating a New Chart

• To start fresh, the instructor deletes the previous chart by selecting it and pressing delete.

• A new column chart is created using only income and expenses data, showcasing each series in distinct colors.

Changing Series Representation

• To change the representation of a series (e.g., expenses), right-click on the corresponding column and select "Change Chart Type."

• Users can choose different representations such as lines or areas for specific data series within the same graph.

Updating Data in Charts

• Charts automatically update when underlying data changes; for example, adjusting expense values reflects immediately in the graph.

• The importance of this feature is emphasized as it ensures that visualizations remain accurate with real-time data updates.

Modifying Axis Scales

• The video discusses changing axis scales; previously shown was how to adjust starting points but not intervals.

• Two methods are provided: through the "Format Axis" option or directly clicking on axis values for quick access to settings.

Conclusion on Graph Customization

Modifying Graph Axes in Excel

Adjusting Axis Values

• To modify the starting point of an axis, adjust the minimum value; for the endpoint, change the maximum value.

• Activating the fixed option prevents text entry in the input box. For example, setting it to 3000 allows values on the axis to increment by three.

• Changing increments to one may lead to display issues if there are too many values for the current text size on the axis.

• If values like 20,000 do not appear, it might be due to axis scaling; adjusting maximum units can resolve this issue.

• After modifying axes, you can explore additional features by changing graph types.

Understanding Circular Graphs

Characteristics of Circular Graphs

• Circular graphs (often called pie charts or cheese charts) can only represent a single data series at a time.

• When attempting to display multiple series (like income and expenses), only one will be represented unless adjustments are made between rows and columns.

• Switching between rows and columns allows representation of different data but limits visibility across multiple months.

Data Representation Limitations

• A circular graph's limitation is that it cannot show more than one series simultaneously without losing other data points.

• If you wish to switch from displaying income to expenses after creating a chart, use the "Select Data" button for easy adjustments.

Enhancing Visual Appeal in Circular Graphs

Adding Data Labels

• To add labels showing values next to each segment in a circular graph, ensure no single series is selected before proceeding with label options.

• You can separate segments visually by dragging them apart; Excel also offers pre-defined styles that automatically create separated segments.

Customizing Label Appearance

• In presentation settings under "Data Labels," you can choose where labels appear (centered or external).

How to Work with Circular Graphs in Excel

Rotating and Formatting Graphs

• The graph can be rotated along different axes (X and Y), changing the perspective from which it is viewed.

• To modify the format or color of data series, right-click on the selected series after ensuring only one is highlighted.

• After selecting a single data series, you can access formatting options like solid fill colors to change its appearance.

Understanding Graph Areas

• A graph consists of three main areas: the chart area (outer zone), plot area (inner zone), and the actual graph where data series are displayed.

• Each area can be modified separately; for example, you can add background colors or patterns to enhance visual appeal.

Adding Text and Shapes

• You can include text boxes or shapes in your graphs by using tools available under the presentation tab in Excel.

• Text boxes allow for custom annotations, such as labeling quarterly expenses directly on the graph.

Drawing Tools in Excel

• Selecting a chart enables specific drawing tools that adapt based on what is selected; this includes adding arrows or other shapes to highlight information.

• The presentation tab provides a gallery of shapes that can be added to charts for better clarity and emphasis.

Introduction to Mini Charts

• Mini charts are a new feature introduced in Excel 2010, designed to fit within a single cell and represent trends visually.

Mini Gráficos en Excel: Cómo Representar Datos

Introducción a los Mini Gráficos

• Se explica cómo seleccionar las celdas que contienen la información para crear un mini gráfico y la ubicación donde se colocará. La ubicación se determina automáticamente al seleccionar una celda antes de abrir la ventana de configuración.

Creación del Mini Gráfico

• Con el cursor parpadeando, se seleccionan los datos correspondientes a enero, febrero y marzo. Al aceptar, se genera un mini gráfico que representa tendencias con la información disponible.

• Se menciona que los mini gráficos funcionan como fórmulas; al arrastrar hacia abajo, se crean gráficos para cada serie de datos. Además, estos gráficos se actualizan automáticamente al modificar los valores en las celdas.

Actualización de Datos

• Si se modifican los gastos (por ejemplo, de 15.500 a 7.000), tanto la tendencia de gastos como la de beneficios cambian automáticamente al pulsar Enter.

Uso de Gráficos de Columnas

• En lugar de líneas, también es posible representar tendencias mediante gráficos de columnas. El rango de datos es el mismo y permite visualizar ingresos, gastos y beneficios en formato columnar.

Personalización del Mini Gráfico

• Los usuarios pueden personalizar colores y resaltar puntos altos o bajos en el gráfico. Esto es útil especialmente cuando hay muchos datos para analizar.

Mini Gráfico de Pérdidas y Ganancias

• Se introduce el mini gráfico específico para pérdidas y ganancias, ideal para mostrar valores negativos. Aunque inicialmente no hay valores negativos en el ejemplo dado, se simula un gasto alto para ilustrar su utilidad.

Visualización Efectiva

• Al introducir un gasto significativo (por ejemplo, 35.000 euros), el mini gráfico refleja pérdidas significativas, proporcionando una visualización clara sobre qué celdas tienen valores negativos.

Reflexiones Finales sobre Mini Gráficos

• Los mini gráficos ofrecen información rápida sobre tendencias financieras y son útiles para identificar rápidamente celdas con valores negativos.

Futuras Exploraciones

• Se menciona la posibilidad futura de realizar cursos más profundos sobre gráficos avanzados o tablas dinámicas según las solicitudes del público.

Conclusión General