I am trying to set up a chart that will have stacked bars overlayed with a
line graph. Is this possible to do?
I am trying to set up a chart that will have stacked bars overlayed with a
line graph. Is this possible to do?
Hi,
Yes it is possible if you are not using the 3d styles.
Create the stacked column chart based on all your data. Then select the
series you want to plot as a line. Use the menu Chart > Chart Type... to
select the required line chart style.
Cheers
Andy
Jan wrote:
> I am trying to set up a chart that will have stacked bars overlayed with a
> line graph. Is this possible to do?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
First make the chart as a stacked columns chart.
IN the chart, right click on the data series to be a line; select Chart Type
and specify Line
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Jan" <[email protected]> wrote in message
news:[email protected]...
>I am trying to set up a chart that will have stacked bars overlayed with a
> line graph. Is this possible to do?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks