Charts & pivot tables
Build, format and fix charts and pivot tables.
- How to Choose the Right Trendline in ExcelChoose an Excel trendline by matching its shape to the pattern and likely relationship in your data, then check whether it fits…
- How to Change Date Format in an Excel ChartTo change date labels in an Excel chart, right-click the date axis, choose Format Axis, then use the Number section to select…
- How to Make a Chart in Excel From a Table: Steps That WorkTo make a chart from a table in Excel, click a cell in the table, choose Insert > Recommended Charts, select a…
- How to Make a Percentage Chart in Excel (With Labels)To make a percentage chart in Excel, select your category labels and percentage values, then choose a chart such as a column…
- How to Make a Chart in Excel With X and Y AxesTo make a chart in Excel with numeric X and Y axes, put the X values in one column and the matching…
- How to Make a Chart in Excel From Your DataTo make a chart in Excel, select the cells containing your data, choose Insert > Recommended Charts, pick a chart, and select…
- How to Make a Chart in Excel Run From Right to LeftTo make an Excel chart read from right to left, select the axis you want to reverse, right-click it, choose Format Axis,…
- How to Make a Chart in Excel: A Clear Step-by-Step GuideTo make a chart in Excel, arrange your information in labeled rows or columns, select the data, then choose Insert > Recommended…
- Wrap Text in Excel Chart X-Axis Labels: Step-by-StepTo wrap text in Excel chart x-axis labels, add a line break to the category label in the worksheet cell that supplies…
- Proper Excel Chart Creation: A Step-by-Step GuideTo create a proper chart in Excel for Microsoft 365 on Windows, arrange your data in a clear table with meaningful headers,…
- Column Chart in Excel: How to Create and Format OneA column chart in Excel displays values as vertical bars, making it easy to compare categories or track changes across periods. To…
- Excel Payment Chart: Build a Loan Schedule and GraphAn Excel payment chart is usually a loan amortization schedule paired with a graph showing how payments are split between interest and…
- Unique Excel Chart Designs: Ideas and How to Build ThemUnique Excel chart designs combine a chart type suited to the data with thoughtful formatting, labels, and context. In Microsoft Excel for…
- Excel Chart Types: How to Choose the Right Chart for DataThere is no single best Excel chart type: choose the one that makes your data’s main message easiest to see. Use a…
- Sort Excel Chart Data and Reorder Categories EasilyTo sort an Excel chart, sort the chart’s source data: select a cell in the data, choose Data > Sort, pick the…
- How to Sort an Excel Chart Without Changing Source DataTo sort an Excel chart without changing its source data, create a separate helper range with a formula such as =SORTBY(A2:B6,B2:B6,-1), then…
- How to Sort an Excel Pie Chart from Largest to SmallestTo sort an Excel pie chart from largest to smallest, sort the chart’s source data by its value column in descending order:…
- Excel Bar Chart Reverse Order: Steps, Options, and FixesYes. Select the bar chart’s category axis, open Format Axis, and under Axis Options turn on Categories in reverse order. This reverses…
- Excel Bar Chart Tutorial: Create and Format OneTo make a bar chart in Excel for Microsoft 365 on Windows, place category names in one column and their values in…
- Excel Bar of Pie Chart: How It Works and When to Use ItAn Excel Bar of Pie chart separates smaller categories from a pie chart and displays those categories as segments in a bar…
- Excel Bar Chart: How to Make Bars Closer TogetherTo make bars closer together in an Excel chart, select a bar, open Format Data Series, and reduce Gap Width. A smaller…
- Excel Bar Chart: How to Make Bars WiderTo make bars wider in an Excel bar chart, right-click a bar, choose Format Data Series, then under Series Options reduce Gap…
- Excel Bar Chart Different Color Bars: How to Set ThemYes. In Excel for Microsoft 365 on Windows, select the chart, right-click a bar, choose Format Data Series, then open Fill &…
- Excel Bar Burndown Chart: Build One Step by StepYes. In Excel for Microsoft 365 on Windows, list each workday, record the actual work remaining, calculate an ideal remaining-work value, then…
- Excel Bar and Line Chart: Create and Format a Combo ChartTo put bars and a line in one Excel chart, select your category labels and data series, then choose Insert > Insert…
- Excel Bar and Whisker Chart: How to Create and Read OneAn Excel bar and whisker chart, more commonly called a box-and-whisker chart or box plot, summarizes the distribution of numeric data using…
- Excel Mini Chart in Cell: Add and Format SparklinesIn Excel, a mini chart displayed in a worksheet cell is called a sparkline. In Excel for Microsoft 365 on Windows, select…
- Monthly Excel Gantt Chart: Build a Clear Project TimelineA monthly Excel Gantt chart shows when tasks begin and end across a calendar, with colored cells marking the months each task…
- Excel Chart Creation: Steps, Choices, and FixesYes—Excel makes chart creation straightforward: select your data, choose Insert > Recommended Charts, pick a chart, and select OK. You can then…
- Access Power Pivot Gallery in Excel or SharePointIf you mean Power Pivot in Excel, open Excel for Microsoft 365 on Windows and select the Power Pivot tab, then choose…