Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create a stacked bar graph?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a rolling 12 week graph | Charts and Charting in Excel | |||
trying to combine 2 columns of data to create one x axis in graph | Charts and Charting in Excel | |||
How can I display two seperate stacked bars in a graph | Charts and Charting in Excel | |||
How do you combine a stacked column and single column graph? | Charts and Charting in Excel | |||
Graph to create a Gant Chart | Excel Discussion (Misc queries) |