Creating a Combination Chart
Franz,
Thanks for your help. Unfortunately, I already tried your suggestion, but
it did not work. Apparently, Excel allows only certain chart types to be
combined. And having a cluster bar and stacked bar on the same chart is not
an allowable combination. Thanks again.
Regards, Bob
"Franz Verga" wrote:
Bob wrote:
I have 3 data series. I would like to make Series 1 a clustered
column, and Series 2 & 3 a stacked column. Is that possible? If so,
could someone kindly tell me how to do it? Thanks in advanced for
any help.
Hi Bob,
First of all built the chart as a clustered column with the 3 series, than
select series 2 right click on it, select Chart Type and select a a stacked
column type; repeat for series 3.
--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|