Excel for the web

Get insights with Ideas

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

Ideas in Excel for the web helps you gain insights into your data through high-level visual summaries, trends, and patterns.

  1. Select a cell in a data range.

  2. Select Home > Ideas.

    The Ideas pane will appear and show different visual and analysis types, such as:

    • Rank

    • Trend

    • Outlier

    • Majority

  3. Choose an option and select Insert PivotChart.

Want more?

Ideas in Excel

Excel help & training

Office for the web Quick Starts

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.