98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » How do I group categories in a column chart | Excel forum
How do I group categories in a column chart | Excel forum
Resolved · Low Priority · Version 2003
Lucy has attended:
Excel Advanced course
How do I group categories in a column chart
How do I group categories in a column chart?
RE: How do I group categories in a column chart
Hi Lucy,
Thank you for your post, welcome to the forum, in answer to your question normally you would be using stacked columns in this type of operation but to group categories follow these steps:
Select cells (your_range), and then click Chart on the Insert menu.
Click the Standard Types tab. Click Column in the Chart type list, click the Stacked Column icon (the second selection) under Chart sub-type, and then click Next.
In step 2 of the Chart Wizard, click the Series tab. In the Series list, click X, and then click Remove.
Type the following in the Category (X) axis labels box:
=Sheet1!(your_range)
Click Next twice to move to step 4 of the Chart Wizard.
Click As new sheet, and then click Finish.
The labels X1 through X5 appear along the horizontal axis. Y1 through Y4 appear in the legend as series names. You can extend this chart to include more groups by adding more data in two rows for each new group.
The number of rows per category label defines the number of stacks per group. To add another group of two bars, insert a row before each X label, and then add two more columns of data in the new row, such as Y5 and Y6.
The number of columns of data per row defines the number of columns in each stack. For example, if the values for Y3 in the chart (displayed in step 1) are moved to the first row of each group, the chart still has two stacks per group. However, the first stack contains three columns and the second stack contains only one column.
I hope that has helped, regards Pete
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Formula for last day of monthIn some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1 |