I found a chart that I wanted to show you how to build.

Companion planting

The printable planting guide is found here. This is what the color means:
Light green : plants grow well together
Red : don´t plant together
Dark green : the combination helps bug control
Yellow : carrots will have good flavor but stunted roots.
Grey : beneficial to garden in general

Instructions

  1. Start typing the plants in cell A2 and below.
    Building a companion planting chart 1
  2. Copy the plant names and right click on cell B1. Click "Paste Special...".
    Building a companion planting chart 2
  3. Click "Transpose" and then click OK button.
  4. Select and right click on cell range B1:AE1.
  5. Click "Format Cells...".
  6. Go to tab "Alignment".
  7. Change "Orientation" to 90 degrees. Click OK.
    Building a companion planting chart 3
  8. Select column B:AE and change column width to 20px.
    Building a companion planting chart 4
  9. Type 1 for green, 2 for red, 3 for grey, 4 for dark green and 5 for yellow in cell range B2:AE31
    Building a companion planting chart 5
  10. Select cell range B2:AE31 and go to tab "Home" on the ribbon.
  11. Click "Conditional formatting" button.
  12. Click "New Rule.."
  13. Select "Use a formula to determine which cells to format"
  14. Type =B2=1
    Building a companion planting chart 6
  15. Click "Format..." button
  16. Go to tab "Fill"
  17. Pick a color
  18. Click OK button twice
  19. Repeat step 11 - 18 for 2, 3, 4 and 5 but the formulas become =B2=2, =B2=3 , B2=4 and B2=5 and the fill colors are different.
    Building a companion planting chart 7
  20. Hide the numbers in cell range B2:AE31. Select B2:AE31 and press CTRL + 1. Click "Custom" category. Type ;;; click OK.
    Building a companion planting chart 8
  21. Apply borders. Select A1:AE31. Go to "Home" tab on the ribbon. Click "Borders" and select "All Borders".
    Building a companion planting chart 9

You could color each cell manually, but in my opinion building this chart is a lot easier using numbers in cells.

Chart posts that may inspire you

Download excel *.xlsx file

Companion-planting-chart.xlsx