Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination chart type
Is there a way to combine Cluster and stacked column Chart types? Showing
some data series in the stacked column and other in another tacked column and than both side to side as a clustered column. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination chart type
SB
There are several sites that will show you techniques for using clustered and stacked bar charts. http://peltiertech.com/Excel/Charts/index.html http://www.andypope.info/charts.htm http://www.stfx.ca/people/bliengme/ExcelTips.htm From a data visualization standpoint, stacked and clustered bar charts are not the best choice. Cleveland's chart interpretation research has shown that chart readers can interprete position along identical, non aligned scales better than length. This page gives a brief introduction to data visualization with Excel and the does and don'ts of Excel charting. Just because Excel has a clustered/stacked chart capability doesn't mean that you should use it. http://processtrends.com/TOC_data_visualization.htm As an alternative to stacked/clustered bar charts, I suggest panel charts, comparable to Tufte's small multiples or Cleveland's trellis charts. http://processtrends.com/toc_panel_charts.htm If you'd like to try panel charts, let me know and I will be glad to walk you through the process. Here's my anti-spam e-mail address. Remove the extra characters if you would like to contact me. ***remove*this** "SB" wrote in message ... Is there a way to combine Cluster and stacked column Chart types? Showing some data series in the stacked column and other in another tacked column and than both side to side as a clustered column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination Chart | Charts and Charting in Excel | |||
Setting up a Custom type, User-defined, Default Chart | Charts and Charting in Excel | |||
Pie chart - type | Charts and Charting in Excel | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
Vertical ND Curve on Combination Chart | Charts and Charting in Excel |