View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do I create a stacked bar graph?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"star1one" wrote in message
...