I want to create a column chart that has one data series on the left axis,
and the other series on the right axis. Pretty easy if you want the 2nd axis
to be a line, but can't figure out how to do this with a column.
I want to create a column chart that has one data series on the left axis,
and the other series on the right axis. Pretty easy if you want the 2nd axis
to be a line, but can't figure out how to do this with a column.
Hi,
You need to stagger your data to stop the 2 sets of columns overlapping
each other.
See here for information.
http://peltiertech.com/Excel/ChartsH...sterStack.html
Cheers
Andy
dguilbault wrote:
> I want to create a column chart that has one data series on the left axis,
> and the other series on the right axis. Pretty easy if you want the 2nd axis
> to be a line, but can't figure out how to do this with a column.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
I have worked out how to do it but unfortunately my two columns sit over/in
front of/behid each other rather than side by side.
"dguilbault" wrote:
> I want to create a column chart that has one data series on the left axis,
> and the other series on the right axis. Pretty easy if you want the 2nd axis
> to be a line, but can't figure out how to do this with a column.
Andy seems to have copied the wrong link. Try this:
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
"dguilbault" <[email protected]> wrote in message
news:[email protected]...
>I want to create a column chart that has one data series on the left axis,
> and the other series on the right axis. Pretty easy if you want the 2nd
> axis
> to be a line, but can't figure out how to do this with a column.
Doh!
Thanks Jon. I have also posted the correct link to the other post I have
used it in.
Cheers
Andy
Jon Peltier wrote:
> Andy seems to have copied the wrong link. Try this:
>
> http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services - Tutorials and Custom Solutions -
> http://PeltierTech.com/
> 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
> http://peltiertech.com/Excel/ExcelUserConf06.html
> _______
>
> "dguilbault" <[email protected]> wrote in message
> news:[email protected]...
>
>>I want to create a column chart that has one data series on the left axis,
>>and the other series on the right axis. Pretty easy if you want the 2nd
>>axis
>>to be a line, but can't figure out how to do this with a column.
>
>
>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks