You don't need VBA for this. Just put row labels on the left andcolumn labels on the top row, select the table and press the chartwizard button. Try different chart types until you like it.