Can I put a secondary axis on a 3-D column chart in MS Excel?

J

jk432897

Can I put a secondary axis on a 3-D column chart in MS Excel? If so, How?
I want to over lay a line on top of a 6x12 row set of 3-D columns.
 
J

Jon Peltier

I don't know about a secondary axis, because I avoid 3D charts. You cannot
make a combination 3D chart, though, so your plan of a line with the columns
will not be possible.

Use a clustered 2D column chart, and add a line or XY series:

http://peltiertech.com/Excel/Charts/AddLine.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
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top