Excel introducción a gráficos

Overview

A step-by-step introductory tutorial showing how to create and work with charts in Excel (Insert > Charts). The demo emphasizes selecting the correct data range and using Excel’s built-in chart recommendations and live previews to choose the best visualization.

Key features and concepts covered

• Charts location
  • Insert tab → Charts group; hovering icons shows short descriptions and recommended use.
• Recommended Charts
  • Excel analyzes the selected data and suggests suitable chart types.
• New/modern features
  • Insert Map Chart (available in Office 2016, 2019, Office 365) and dynamic charts.
• Chart categories discussed
  • Column/Bar (grouped, stacked, 100% stacked)
  • Line
  • Pie
  • Hierarchy
  • Statistical
  • Waterfall
  • Funnel
  • Etc.
• Previews
  • Excel shows a preview of how a chart will look before inserting; useful for comparing grouped vs. stacked views.
• Chart Design & Format tabs
  • Appear when a chart is selected and provide options to change styles, colors, and chart type.
• Change Chart and Switch Row/Column
  • Convert between chart types and reorient series/categories.
• Select Data
  • Edit which series and categories are shown (for example, show only totals or a specific month).
• Multiple charts and sheets
  • Create multiple charts, move charts to a new sheet (Move Chart), and maintain live links so charts update when source data changes.
• Deleting charts or chart sheets
  • Charts can be deleted individually or by removing the sheet.

Practical tips taught in the demo

• If you select just one cell in a data range, Excel will still detect the full range for charting.
• Hover over chart icons for guidance on when to use each type.
• Try different chart previews and styles to find the best visual fit; use the Select Data dialog to refine what appears.
• Use separate sheets to organize charts while keeping them linked to the original table for automatic updates.

Tip: Use Recommended Charts and the preview feature to quickly compare visual options before inserting a chart.

Structure of the tutorial

1. Select data.
2. Use Recommended Charts.
3. Insert a column/bar chart.
4. Explore Chart Design options.
5. Change chart type as needed.
6. Use Select Data to refine series and categories.
7. Move charts to new sheets.
8. Demonstrate that charts update when source data changes.

Main speaker / source

Unnamed instructor/presenter demonstrating Excel’s charting features using Microsoft Excel (Office 2016–365 features).