If you want finer control of the alignment of the labels, insert a second line between the each pair of labels and set the font size for the second lines in a smaller font than the first lines. Continue with the three remaining labels. Select the blank line between the first two labels in the text box and change the line's font size so that, again by eye, the second label is aligned vertically with the center of the second grid row. Move the text box vertically so that, by eye, the first of labels in the text box is by eye aligned vertically with the center of the top row of the grid. Enter into the text box the vertical axis labels that you want to show, with a blank line between each label, and with the font size and color of your choice. Select the chart area and then insert a text box over the vertical axis label area. At this point, you may want to shift the plot area to the left so that there is more white space between the right borders of the plot area and the chart area. Set the major tick mark type of the vertical axis to None, and the font color of the vertical axis labels to white. If you want to change the font size of the labels of one of the axes, be sure to set the other axis to the same size to preserve the square grid layout. (I am unaware of any way to dynamically set the colors of the grid cells based upon different data values, other than via VBA.) Select and set the fill color of each data point (grid cell) that you want in a contrasting color. Select the chart area and set its height and width to identical values. Select each band (data series) and set its fill color to solid fill white and its border color to solid line black. Insert a chart title and horizontal and vertical axis titles, if any. Select one of the bands to format and set its Gap Width to "No Gap.". You will now have a chart with of bars with five horizontal bands, each of a different color. Selecting the 6 x 5 cell range, insert a 100% Stacked Column chart into the worksheet. In the 5 x 5 cell range immediately below, enter the value 1 in each cell. Custom Chart Types and Chart Formatting Tools for Microsoft Excel Purchase Peltier Tech Charts For Excel Advanced Edition 99 US Standard Edition 79 US View Cart GENERAL FEATURES OF PELTIER TECH CHARTS FOR EXCEL. 
Enter what will be the horizontal column labels in a 1 x 5 cell range in your worksheet.For the most part, these steps can be taken in any order.
Since you don't want to use VBA, there are a number of hand steps that are needed to create the grid chart you are looking for.
0 kommentar(er)
