Excel Advanced Visualizing Data with Charts
ADVANCED Visualizing Data with Charts
Create and work with Excel charts by choosing chart types inserting charts resizing and moving them adding data and switching rows and columns.
Visualizing Data with Charts Overview
Charts turn worksheet data into a visual presentation. This topic focuses on creating charts choosing chart types inserting charts resizing and moving them adding additional data and switching between rows and columns.
A chart is linked to worksheet data so the selected data and its arrangement determine what the chart displays.
Essential Terms
Review the main terminology used when creating and adjusting charts.
Create Charts
Begin by understanding charts and chart types then use an appropriate insertion method to create a chart from worksheet data.
Chart Types and Insertion
The chart type determines how the selected data is represented while the insertion method determines how the chart is created in Excel.
Charts
Charts provide a visual representation of worksheet data.
Chart Types
Different chart types present data in different visual structures.
Insertion Methods
Chart insertion methods are used to create a chart from selected worksheet data.
Chart Creation Workflow
A practical chart workflow starts with worksheet data and continues through chart creation and adjustment.
Modify the Chart
After creating a chart resize or move it add additional data when required and change how rows and columns are interpreted.
Interactive Chart Explorer
Explore the major chart tasks included in this topic.
Key Takeaways
Creating a chart is only the beginning. Review the chart and adjust its data arrangement position and size as required.
Select the appropriate worksheet data and chart type before creating the chart.
If the chart interprets the worksheet data in the wrong orientation switch between rows and columns.
Knowledge Check
Test your understanding of creating and modifying Excel charts.