Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked column chart
How do you add multi columned data to a stack chart without all of the
information stacking in one colum? For example I have 2 types of date for to compare for multiple years. Is the possible? if not any sugguestion on a different type of chart to use? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked column chart
"Photochoc" wrote: How do you add multi columned data to a stack chart without all of the information stacking in one colum? For example I have 2 types of date for to compare for multiple years. Is the possible? if not any sugguestion on a different type of chart to use? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked column chart
Set your chart type to the stacked bar. Entering your data into the
datasheet: your years should be the column headings - separate each year by one column with 0 data. Your rows should contain the data for the two dates (the two dates will be your row titles). You can show the 2 dates on the graph by a) using the legend or b) using a data table with legend. Be sure to click on each part of the stacked bar to make them different colors - shadows sometimes help differentiate them clearly also. Does this help? "Photochoc" wrote: How do you add multi columned data to a stack chart without all of the information stacking in one colum? For example I have 2 types of date for to compare for multiple years. Is the possible? if not any sugguestion on a different type of chart to use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to combine stacked column with a cluster column chart? | Charts and Charting in Excel | |||
Stacked Column Chart / Normal Column Chart | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
Stacked Column Chart | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |