Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combination bar Charts
I have three data series on a bar chart. I want two of them stacked, and the
third remaining singular (cluster bar format). I know how to change one data series to a line, but when I try to change one to a singular bar using the same techique (highlighting the singular series and selecting a different chart type), the entire chart type switches to clustered bars. Is there any way to do this? I would like to create a custom chart type in this format, but it is unclear how to create chart custom formats. |
#2
|
|||
|
|||
Jon Peltier has information and links for clustered stacked columns on
his web site: http://peltiertech.com/Excel/ChartsH...sterStack.html Nacy wrote: I have three data series on a bar chart. I want two of them stacked, and the third remaining singular (cluster bar format). I know how to change one data series to a line, but when I try to change one to a singular bar using the same techique (highlighting the singular series and selecting a different chart type), the entire chart type switches to clustered bars. Is there any way to do this? I would like to create a custom chart type in this format, but it is unclear how to create chart custom formats. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination Charts | Charts and Charting in Excel | |||
Combination Charts | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
How do I create my own custom combination charts? | Charts and Charting in Excel | |||
Combination Charts | Excel Discussion (Misc queries) |