Home > Excel Topics > Charts

Excel Charts - From Basic to Advanced

Excel Charts - Basic

The following pages have basic Excel chart tutorials, with videos, written steps, and sample files.

Combo -- Combine line and column series in a single Excel chart. Plot line on secondary axis. Step by step instructions and video. Details on the Excel Line Column Chart With 2 Axes page.

Pie -- How to make Excel pie chart, avoid problems. Videos, written steps. Good, bad examples. Format, add pictures, percentages, labels for best pie chart results. Details on the Excel Pie Chart Good Bad Examples Videos page.

Unhide Data -- How to fix a chart when some data is hidden. Details on the Quick Fix Unhide Data - Excel Chart - Excel Sparkl page.

Excel Charts - Advanced

The following pages have advanced Excel chart tutorials, with videos, written steps, and sample files.

Box Plot -- How to make Excel Box Plot chart to show distribution of data set numbers. Step-by-step box plot Excel videos, written steps, free workbook. Details on the How to Make Excel Box Plot Chart (Box and Whisker) page.

Cluster Stack -- How to set up Excel data to create cluster stack column chart or bar chart. Add blank rows to space the data. Get free Excel file with sample data and charts. Details on the Excel Clustered Stacked Column Chart page.

Date Range -- Select start and end dates, Excel chart shows sales for date range. Uses dynamic named ranges - Excel table or OFFSET formulas. Download Excel file. Details on the Excel Chart for Selected Date Range page.

Date Range -- How to set up interactive Excel chart. Set date range, use check boxes, drop down lists, to show data in chart. Get free Excel workbook. Details on the Excel Interactive Chart Date Range page.

Gantt -- Easy steps to create simple Gantt chart in Excel for project planning. Type task names and duration, chart shows timeline. Video, written steps, free workbook. Details on the Easy Steps to Make Excel Gantt Chart page.

Interactive -- How to add interactive features for Excel charts. Click check box or type X in cell to show and hide chart data, no macros. Get free workbook with chart. Details on the Make Interactive Excel Charts No Macros page.

Macros -- Excel macros to delete charts, export chart as picture, custom color pie charts, add remove error bars. Details on the Excel Chart Macros page.

Marimekko -- Create Marimekko chart with colour blocks for market segment share. Variable width 100% stacked bar chart. Mekko graph, mosaic plot, matrix chart. Details on the How to Build Marimekko Chart page.

Panel Chart -- How to build an Excel panel chart (trellis chart). Watch step by step video and download free workbook. Details on the How to Build Excel Panel Chart page.

Seating -- How to create Excel seating plan. Assign wedding guests table number, seat number. Name list, visual chart. Step by step instructions, free workbook. Details on the Excel Seating Plan Guest Tables page.

Target Range -- How to show target range in Excel line chart for monthly sales data. Easy steps and data setup. Written steps, video, free workbook. Details on the Show Target Range in Excel Line Chart page.

Waterfall -- Create Excel Waterfall chart to show how plus and minus amounts affect total amount, based on starting value. Sample files, video, written steps. Details on the Create Excel Waterfall Chart page.

Video: Line Chart With Target Range

In this video, see how to build an Excel line chart to show sales over six months, and show the target sales range in the chart's background. In the data, add the high and low values for the target range, and show that range in the background of the line chart.

For written steps, go to the Create an Excel Line Chart with Target Range page

Get Monthly Excel Tips!

Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.

Next, when you get my reply, please click the Confirm button. I add this step to protect you from spam!

Excel Topics

Data Validation | Pivot Tables | Formulas | Data | Macros | Format | Charts | Filters | Structure