How do I create a stacked bar graph?
|
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 ... |
All times are GMT +1. The time now is 05:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com