PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Can I put a secondary axis on a 3-D column chart in MS Excel?

Reply

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

 
Thread Tools Rate Thread
Old 06-04-2006, 05:46 PM   #1
=?Utf-8?B?ams0MzI4OTc=?=
Guest
 
Posts: n/a
Default Can I put a secondary axis on a 3-D column chart in MS Excel?


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.
  Reply With Quote
Old 07-04-2006, 12:57 AM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: Can I put a secondary axis on a 3-D column chart in MS Excel?

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
_______

"jk432897" <jk432897@discussions.microsoft.com> wrote in message
news:922DB86F-0A96-4013-813B-2BAFB4C69196@microsoft.com...
> 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.



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off