I am struggling to create a chart that combines stacked columns on one X axis
with a line on a second axis. Both are available as standard charts.
I am struggling to create a chart that combines stacked columns on one X axis
with a line on a second axis. Both are available as standard charts.
Hi,
Create the stacked column chart with all of your data.
Select the data series you want to plot as a line on the secondary axis.
Change the chart type to line. And then on the format dialog change the
axis to the secondary.
Cheers
Andy
ian ian ian rogers wrote:
> I am struggling to create a chart that combines stacked columns on one X axis
> with a line on a second axis. Both are available as standard charts.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks