Group Axis Can You See It Again
How to grouping (two-level) axis labels in a chart in Excel?
For example you take a purchase table as below screen shot shown, and y'all need to create a column nautical chart with two-lever Ten centrality labels of date labels and fruit labels, and at the aforementioned fourth dimension appointment labels are grouped by fruits, how to solve information technology? This commodity provides a couple of ways to help you group (two-level) centrality labels in a chart in Excel.
- Group (2-level) axis labels with adjusting layout of source data in Excel
- Group (2-level) axis labels with Pivot Nautical chart in Excel
Group (two-level) axis labels with adjusting layout of source data in Excel
This first method will guide you to change the layout of source data earlier creating the column nautical chart in Excel. And you can do as follows:
1. Motility the fruit column before Date column with cutting the fruit column and so pasting before the date column.
2. Select the fruit cavalcade except the column heading. In our example, delight select the Range A2:A17, and and so click the Sort A to Z push on the Information tab.
3. In the throwing out Sort Warning dialog box, keep the Expand the option option checked, and click the Sort push.
4. In the fruit column, select the first series of same cells, says A2:A6, and click Home > Merge & Center. And and then click the OK button in the popping Microsoft Excel dialog box. See beneath screenshots:
And then the commencement series of adjacent cells filled by Apple are merged. Meet below screenshot:
5. Repeat Step 4 and merge other adjacent cells filled with same values.
Tip: One click to merge all adjacent cells filled with aforementioned value in Excel
If you have Kutools for Excel installed, you can use its Merge Same Cells utility to merge all next cells which contain aforementioned value with only 1 click. Full Characteristic Free Trial 30-24-hour interval!
6. Select the source information, so click the Insert Column Chart (or Column) > Cavalcade on the Insert tab.
Now the new created column chart has a two-level X axis, and in the X axis appointment labels are grouped by fruits. See below screen shot:
Group (2-level) axis labels with Pivot Chart in Excel
The Pivot Nautical chart tool is so powerful that it can help you lot to create a chart with one kind of labels grouped by another kind of labels in a 2-lever axis easily in Excel. You can practise as follows:
ane. Create a Pivot Chart with selecting the source data, and:
(1) In Excel 2007 and 2010, clicking the PivotTable > PivotChart in the Tables group on the Insert Tab;
(2) In Excel 2013, clicking the Pin Nautical chart > Pivot Nautical chart in the Charts grouping on the Insert tab.
2. In the opening dialog box, check the Existing worksheet option, and and then select a cell in current worksheet, and click the OK button.
3. Now in the opening PivotTable Fields pane, drag the Date field and Fruit field to the Rows department, and drag Amount to the Values section.
Notes:
(i) The Fruit filed must be above the Date filed in the Rows section.
(2) Apart from dragging, you tin can also right click a filed, and then select Add to Row Labels or Add to Values in the right-clicking menu.
Then the appointment labels are grouped by fruits automatically in the new created pivot chart equally below screen shot shown:
Demo: Grouping (two-level) axis labels in normal nautical chart or PivotChart
Kutools for Excel includes more than 300 handy tools for Excel, free to attempt without limitation in 30 days. Download and Free Trial Now!
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Issues, and Increases Your Productivity by fourscore%
- Reuse: Apace insert complex formulas, charts and annihilation that yous have used earlier; Encrypt Cells with countersign; Create Mailing List and send emails...
- Super Formula Bar (hands edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Forestall Indistinguishable Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Bare Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without irresolute formula reference; Car Create References to Multiple Sheets; Insert Bullets, Cheque Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Impress Paging Subtotals; Catechumen Betwixt Cells Content and Comments...
- Super Filter (salve and utilise filter schemes to other sheets); Avant-garde Sort past month/calendar week/twenty-four hour period, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Role/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features xxx-day free trial. threescore-day money back guarantee.
Office Tab Brings Tabbed interface to Function, and Make Your Piece of work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Projection.
- Open and create multiple documents in new tabs of the aforementioned window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every solar day!
stewartnineirackly1994.blogspot.com
Source: https://www.extendoffice.com/documents/excel/2715-excel-chart-group-axis-labels.html
0 Response to "Group Axis Can You See It Again"
Postar um comentário