Chart with a Dual Category Axis. Through appropriate arrangement of your source data, you can give your chart a dual category axis. This approach works with chart types that have an Category type category X axis, that is. The chart below shows defect rates in several different components, which are grouped into a smaller number of categories. The data arrangement is shown in the following table ABCDE1. Create-a-Pareto-Chart-in-MS-Excel-2010-Step-4-Version-2.jpg/v4-728px-Create-a-Pareto-Chart-in-MS-Excel-2010-Step-4-Version-2.jpg' alt='Pareto Chart Excel 2003' title='Pareto Chart Excel 2003' />How to Create a Chart from a Pivot Table. Charts are used to provide a graphical representation of a concept or point. Pivot charts created in Microsoft Excel can be. Mechanical. Electrical. Hydraulic. 2Mechanical. Gear. 11. 3Bearing. Motor. 35. Electrical. Install Windows Xp Iso In Virtualbox Usb more. Switch. 19. 6Plug. Cord. 11. 8Fuse. 39. Bulb. 21. 0Hydraulic. Pump. 41. 1Leak. 31. Seals. 1There are three categories Mechanical, Electrical, and Hydraulic. These categories are listed in the first column, and also in the first row. The second column shows the sub categories, for example, Gear, Bearing, and Motor under Mechanical. The cells filled with yellow should be completely blank. The first two cells in the top row are blank to instruct Excel to use the first row as series names and the first two columns as category labels. JBd8hOlIq.png' alt='Pareto Chart Excel 2003' title='Pareto Chart Excel 2003' />The blank cells under each main category in the first column tells Excel that each main category applies to several subcategories. I used separate columns for the three categories so that each is plotted in its own series, making it easier to format each major category separately. To make the chart, select this entire data range and insert a stacked column, stacked bar, or unstacked line chart. Note you could use clustered column or bar charts, but then you would have to format each to use an overlap of 1. The column chart type is probably the best selection see top of page, as long as there are not too many categories and subcategories. The line chart above gives more emphasis to an illusory relationship between points by connecting them with lines. The bar chart below works almost as well as the column chart, but Excel provides no way to orient the major categories horizontally. First in a series. M-RYWjJi0CM/hqdefault.jpg' alt='Pareto Chart Excel 2003' title='Pareto Chart Excel 2003' />Here are some quick keyboard shortcuts in Excel to help you survive in the pivot table jungle. Keyboard shortcut to Sort Fields and Items in a Pivot Table. Download free Microsoft Excel templates and spreadsheets, including Budget Templates, Calendar Templates, Schedule Templates, and Financial Calculators. Learn how to create a dynamic chart range that instantly updates Excel charts when the data changes. Done using OFFSET and INDEX function. Excellike Data Display. Sort, filter, group, and outline flat and hierarchical data to get the view you need. Table formatting and conditional formatting are also. Combinations and Permutations for MBAs and Business Managers Clear and Complete with LOTS OF SOLVED PROBLEMS. Excel 2013 Statistical Analysis 12 Cross Tabulation Charts For Two Variables, Simpsons Paradox Duration 1837. ExcelIsFun 20,907 views.