New Excel Charts for Dashboards: What to Use

Yes. Excel for Microsoft 365 includes several chart types that can make dashboards more informative, including waterfall, funnel, histogram, Pareto, box-and-whisker, treemap, sunburst, and filled map charts. They are useful when they match the question your dashboard needs to answer; for many comparisons and trends, a well-labeled bar or line chart is still the clearer choice.

What counts as a new Excel chart?

People often search for new Excel charts expecting a recent release or a special dashboard gallery. In practice, the phrase usually refers to chart types added to modern Excel compared with older versions, or to newer-looking ways of presenting existing data. Several specialized chart types have been available in desktop Excel for years, and are included in Microsoft 365. Their availability does not mean every one belongs on a dashboard.

A chart is a visual summary of data, not a dashboard by itself. A dashboard typically combines a small set of charts with key figures, labels, and sometimes filters. Its purpose is to help someone notice a result or change quickly. A new chart type is worth using when it makes a particular relationship easier to see, not simply because it looks different.

Excel for Microsoft 365 on Windows is the focus here. Some chart types, data connections, and controls can differ in Excel for the web or on Mac. If a chart command is missing, check the Excel version and platform before assuming that the workbook is damaged.

Excel chart types that can add useful context

Each specialized chart answers a different kind of question. These examples describe sensible uses, not a ranking of the best charts:

Waterfall: Shows how positive and negative changes combine to move a starting value to an ending value. It can explain a monthly profit bridge, such as the contribution of sales, costs, and adjustments to a final result.
Funnel: Shows values across ordered stages, such as leads, qualified prospects, and completed sales. It is most useful when stages form a process and the widths make the drop-off easy to compare. It is not a good fit for unrelated categories.
Histogram and Pareto: A histogram groups numeric observations into ranges to show a distribution, such as delivery times. A Pareto chart combines descending columns with a cumulative percentage line, helping show which categories account for much of a total.
Box and Whisker: Summarizes the distribution of values across groups, including the median, quartiles, and potential outliers. It is useful for comparing variation between teams or products, but may need explanation for readers unfamiliar with statistical charts.
Treemap and Sunburst: Display hierarchical categories, such as department, product family, and item. A treemap uses nested rectangles; a sunburst uses rings. They can show how subcategories contribute to a whole, but small categories can become difficult to read.
Filled Map: Shades geographic areas according to a value, such as sales by state or country. It works best when locations are named clearly and the geographic comparison is meaningful. It is not a substitute for a route or point-location map.

Excel also has familiar chart types that often outperform specialized ones on a dashboard. A line chart shows movement over time, a bar or column chart compares categories, and a scatter chart shows the relationship between two numeric measures. Use a pie or doughnut chart sparingly: it is difficult to compare many slices or slices with similar values.

Choose a chart by the question, not its appearance

Start by writing down what a dashboard reader should learn from each visual. If the question is which region had the most sales, use a sorted bar chart. If it is whether daily demand is rising, use a line chart. If it is why a total changed from one period to another, consider a waterfall. This simple test prevents a visually impressive chart from obscuring the result.

Consider the data as well as the question. A histogram needs numeric observations that can be grouped into bins; a map needs geographic categories Excel can recognize; and a treemap needs a hierarchy with values. If the source data does not fit the chart’s structure, changing the chart type will not fix the underlying problem. Reshape or clean the data first.

Use bars or columns for a manageable number of category comparisons.
Use lines for ordered time periods, especially when the direction of change matters.
Use a scatter chart for paired numeric measures, rather than connecting unrelated categories with a line.
Use a specialized chart only when its distinctive structure makes a real pattern easier to understand.

Insert and configure a chart in Excel 365

For a standard chart, select the data and choose Insert > Recommended Charts. Review the suggestions, or open the All Charts tab in the dialog to choose a chart family. For specialized types, use the relevant chart controls on the Insert tab: statistical charts include Histogram, Pareto, and Box and Whisker; hierarchy charts include Treemap and Sunburst; and the waterfall and funnel options are available in their chart group. For a filled map, choose Insert > Maps > Filled Map. The exact layout of ribbon groups can vary with window size.

Before inserting a chart, make the source easy to interpret. Put one field name in each column, keep each observation in a row, and avoid blank rows inside the data. Include clear headings and values in a consistent format. If the chart has the wrong series or category labels, choose Chart Design > Select Data to inspect or change the source range.

Once the chart is inserted, use Chart Design to change its type, select a layout, or choose colors. Add a useful title and axis titles where the reader needs them. A title such as Sales by Month is more informative than Chart Title. Keep labels and legends only when they help explain the data; decorative effects and heavy gridlines can compete with the information.

On Mac, Excel has similar chart tools on the Insert tab, but ribbon placement and dialog details can differ. Excel for the web also supports many common charts, but some advanced chart editing options may not be available there. When a workbook uses a specialized chart, desktop Excel is the safer place to make detailed changes.

Build a dashboard around reliable source data

A chart can only be as dependable as its source. For a dashboard that will be refreshed, place the underlying records in an Excel table using Insert > Table. Tables expand when new rows are added, which helps keep chart sources current when data is appended. Confirm that totals, dates, and categories are stored as the right data types; a date stored as text, for example, may not behave like a date axis.

For summaries, a PivotTable can group and aggregate records before they are charted. Select a cell in the data and choose Insert > PivotTable, then arrange fields into rows, columns, values, and filters. To create a PivotChart from a PivotTable, select within it and choose PivotTable Analyze > PivotChart. Refresh the PivotTable after its source data changes. A chart connected to a PivotTable reflects the summary, not necessarily every detail in the source records.

For a dashboard with several visuals, arrange the source data consistently and make clear which charts share filters or time periods. Keep a visible reporting date or period so readers know what they are seeing. If different visuals use different date ranges or definitions, label that difference rather than letting the dashboard suggest that the figures are directly comparable.

Add interaction without making the page confusing

Slicers let readers filter PivotTables and PivotCharts through clickable buttons. Select a PivotTable or PivotChart and choose PivotTable Analyze > Insert Slicer, then select the fields to expose. A timeline can filter a PivotTable by date when the source contains valid dates. To have one slicer control multiple PivotTables, use the slicer’s Report Connections or PivotTable Connections command and select compatible PivotTables that share the same source or data model.

Filters are useful when a reader needs to inspect a region, product, or period. Too many slicers, however, turn a compact overview into a control panel that requires explanation. Include only the filters that answer common questions, use clear labels, and make the selected state visible. Test interactions across all connected visuals so the same filter does not produce inconsistent results.

Standard charts linked directly to worksheet ranges do not automatically behave like PivotCharts with slicers. If interactive filtering is central to the design, consider building the summary with PivotTables and PivotCharts, or plan another supported way to update the chart source. Do not promise interactivity based only on the appearance of a chart.

Design choices that make dashboard charts readable

Use a consistent color meaning across the dashboard. If blue represents actual results in one visual, avoid using blue for a different concept elsewhere. Reserve a contrasting color for an important comparison or exception rather than coloring every series differently. A restrained palette also makes it easier to spot the values that matter.

Keep the number of categories and series manageable. Long category names are usually easier to read in a horizontal bar chart than in narrow columns. If a legend forces readers to match many colors to many series, simplify the chart, split it into smaller views, or focus on the relevant categories. Do not rely on color alone to communicate a critical distinction; labels or direct annotations can help readers who have difficulty distinguishing colors.

Match the scale to the story without distorting it. A bar chart generally needs a value axis that starts at zero because bar length represents magnitude. A line chart may use a narrower scale when the task is to inspect small changes, but label the axis clearly so readers do not mistake the amount of variation. Remove unnecessary borders, 3-D effects, and visual decoration that makes comparisons harder.

Common problems and how to prevent them

Charts that omit recent records often have a fixed source range that did not expand when new data was added. An Excel table can reduce this risk for appended data, but check the chart source after changing the workbook structure. A PivotChart may instead need its PivotTable refreshed. Neither step corrects incorrect or missing source records.

Maps can misidentify ambiguous place names, particularly when a label could refer to more than one location. Add a country or region field to clarify the geography and review the plotted results. Map charts may also depend on connected online services, so organizational privacy settings, network access, or service availability can affect whether a map is created or displayed.

Other common issues include dates treated as text, totals included as if they were another category, and blank cells displayed in a misleading way. Check the source and the chart’s Select Data settings before changing colors or rebuilding the visual. For specialized charts, also verify that the input columns follow the expected structure; for example, a waterfall chart may need values identified as totals rather than ordinary changes.

When a different tool or chart is better

Excel is a practical choice when the audience already works with the workbook and the dashboard is modest in size. For a recurring report that needs controlled sharing, row-level permissions, or a larger refreshable model, Power BI may be more appropriate. It is a separate product with its own licensing and publishing considerations, so it should not be treated as a chart button inside Excel.

Even within Excel, a table with conditional formatting can be clearer than a chart when readers need exact values for many rows. A bar chart may be clearer than a treemap when precise category comparisons matter. Choose the simplest visual that lets the intended reader answer the intended question accurately.

Frequently Asked Questions

What is the best Excel chart for a dashboard?
The best choice depends on the question. Bar charts compare categories, line charts show trends over time, and specialized charts such as waterfall or histogram charts are useful for specific structures. A dashboard often works best with a small mix rather than one chart type for everything.

Does Excel 365 have a dashboard chart template?
Excel offers Recommended Charts and workbook templates, but a recommended chart is not a complete dashboard design. You still need to select appropriate data, decide which measures matter, and arrange charts and filters for the intended audience.

How do I make an Excel chart update when I add data?
Use a well-structured Excel table as the chart source where suitable, and check that the chart includes the intended fields. If the chart is based on a PivotTable, refresh the PivotTable after the source data changes.

Why is my map chart option missing in Excel?
Check that you are using a supported desktop version of Excel and that the command is available on the Insert tab. Availability and display can also be affected by platform, connected experiences, network access, or organizational settings.

Can Excel slicers control regular charts?
Slicers are designed to filter tables and PivotTables, and they can control connected PivotCharts when their PivotTables are compatible. A standard chart linked directly to a worksheet range does not gain slicer behavior automatically.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.