I am trying to create a chart with a stacked column plotted on the primary
axis and a line on the secondary axis. I have seen the custom chart type of
a Line - Column chart, but I want to stack the columns. Is this possible?
I am trying to create a chart with a stacked column plotted on the primary
axis and a line on the secondary axis. I have seen the custom chart type of
a Line - Column chart, but I want to stack the columns. Is this possible?
Hi,
Ignore the builtin custom types and just create your own.
Start with a stacked column chart of all your data and then double click
the series that you want on the secondary axis. Change the setting to
secondary via the Axis tab of the format dialog.
Then right click the series and change the chart type to Line.
Cheers
Andy
GSchool wrote:
> I am trying to create a chart with a stacked column plotted on the primary
> axis and a line on the secondary axis. I have seen the custom chart type of
> a Line - Column chart, but I want to stack the columns. Is this possible?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Thank you very much!
"Andy Pope" wrote:
> Hi,
>
> Ignore the builtin custom types and just create your own.
> Start with a stacked column chart of all your data and then double click
> the series that you want on the secondary axis. Change the setting to
> secondary via the Axis tab of the format dialog.
> Then right click the series and change the chart type to Line.
>
> Cheers
> Andy
>
> GSchool wrote:
> > I am trying to create a chart with a stacked column plotted on the primary
> > axis and a line on the secondary axis. I have seen the custom chart type of
> > a Line - Column chart, but I want to stack the columns. Is this possible?
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks