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.

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