J
Jon Peltier
Start with your data nicely arranged. Put the category labels in the
leftmost column of your data range, but series names in the top row of the
range. The intersection of these two (i.e., the top left cell) should be
blank. Put the values in the columns under the series names. Don't skip any
whole rows or columns, though blank cells are okay, they'll be treated like
zeros.
Select the range, run the chart wizard (the button that looks like a column
chart on the Standard toolbar, or go to Insert menu > Chart). Select the
stacked bar (or column if you want vertical bars) is step 1, select the
Series in Columns option in step 2, and press Finish.
- Jon
leftmost column of your data range, but series names in the top row of the
range. The intersection of these two (i.e., the top left cell) should be
blank. Put the values in the columns under the series names. Don't skip any
whole rows or columns, though blank cells are okay, they'll be treated like
zeros.
Select the range, run the chart wizard (the button that looks like a column
chart on the Standard toolbar, or go to Insert menu > Chart). Select the
stacked bar (or column if you want vertical bars) is step 1, select the
Series in Columns option in step 2, and press Finish.
- Jon