Excel Chart Guides
Choose the chart around the question your data needs to answer. A trend over time, a relationship between two measurements, and a project schedule need different layouts. Start with a line or scatter chart for a small table, then use the PivotChart and Gantt guides when you need summaries or a timeline. The archive also includes an older Excel for Mac example; check its version before following the interface steps.
Plot a trend or relationship
- Make a line graph
Set up a chart for a sequence of values and adjust its presentation.
- Make a scatter plot
Plot paired measurements to examine how the values relate.
Summarize data or plan a schedule
- Build a PivotChart
Chart a summary of your data and explore it with filters.
- Build a Gantt chart
Arrange tasks and dates into a project timeline.
All articles on this topic
6 articles
Waterfall Chart in Excel: Set Totals Correctly
Create a waterfall chart in Excel with signed changes, subtotals, and a closing balance. Use Set as Total to fix floating totals and check the result....
How to Make a Gantt Chart in Excel
Make a Gantt chart in Excel with start dates and durations. Follow a five-task example, fix date-axis settings, and download the sample workbook....
Pivot Charts: An All-Encompassing Guide
Pivot charts are often the best way to spot trends or errors, and a better way to present your data. Here's everything you need to know to make them in Exel...
Ready, Set, Scatter: How to Make a Scatter Plot in Excel
This article consists of all the basics of how to make a scatter plot in Excel. By using the guide, readers will be able to generate their own plots as well as format them and add design features....
How to Make a Line Graph in Excel
Organize data by learning how to make a line graph in Excel. Present information over time with this simple guide to creating a line graph....
My First Excel 2011 Chart
My first chart made in Excel 2011 with a data table below, a sparkline chart, and a picture of the ski slope. The chart shows break a event point....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us