![]() With your table completed, you are ready to create the chart. Place your data into the table, beginning at cell B3.Place your row labels into column A, beginning at cell A3.The second major group title should now be centered over the second group of column labels. Select cells E1:G1 and click the Merge and Center tool.(In Excel 2007 the Merge and Center tool is in the Alignment group of the Home tab on the ribbon.) The first major group title should now be centered over the first group of column labels. Select cells B1:D1 and click the Merge and Center tool.In cells B2:G2 place your column labels. ![]() Put your second major group title into cell E1.In the first row, put your first major group title into cell B1.You could set them up as follows:ΔΆ | | Pro | Team | Reg | Pro | Team | Reg | ![]() These column titles will end up as your X-axis labels. Go ahead and set up your worksheet to reflect the column titles the way you want them. Setting up such an arrangement in an Excel worksheet is easy, but getting the same result in a chart may not be as obvious. For instance, you may want something similar to the following along the X-axis for your chart: With some types of data, you may have a need for two-level axis labels for your chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |