PC Review


Reply
Thread Tools Rate Thread

3D stacked bar and line chart on same graph

 
 
snoopy
Guest
Posts: n/a
 
      9th Mar 2010
Using Excel 2007, I have created a 3D stacked bar chart and now need to add a
3D or 2D line chart (different Y data set, same X) with the 2nd Y axis. I
have
tried using the online manuial but haven't found anything useful. Does
anyone have a suggestions for me to try?

Thanks
--
-snoopy
 
Reply With Quote
 
 
 
 
Andy Pope
Guest
Posts: n/a
 
      10th Mar 2010
Hi,

You can not mix chart types when using the 3d variety. Nor can you have
secondary axes.
Use 2d style.

Cheers
Andy


On 09/03/2010 19:45, snoopy wrote:
> Using Excel 2007, I have created a 3D stacked bar chart and now need to add a
> 3D or 2D line chart (different Y data set, same X) with the 2nd Y axis. I
> have
> tried using the online manuial but haven't found anything useful. Does
> anyone have a suggestions for me to try?
>
> Thanks


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

 
Reply With Quote
 
snoopy
Guest
Posts: n/a
 
      10th Mar 2010
Thanks. I can stop spending any more time to try to make this happen.

-snoopy


"Andy Pope" wrote:

> Hi,
>
> You can not mix chart types when using the 3d variety. Nor can you have
> secondary axes.
> Use 2d style.
>
> Cheers
> Andy
>
>
> On 09/03/2010 19:45, snoopy wrote:
> > Using Excel 2007, I have created a 3D stacked bar chart and now need to add a
> > 3D or 2D line chart (different Y data set, same X) with the 2nd Y axis. I
> > have
> > tried using the online manuial but haven't found anything useful. Does
> > anyone have a suggestions for me to try?
> >
> > Thanks

>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>
> .
>

 
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stacked bar, bar and line graph JoAnn Microsoft Excel Charting 1 8th Aug 2008 10:45 PM
Stacked Bar and Line on Same Graph =?Utf-8?B?Sm9obkFtY29yRg==?= Microsoft Excel Charting 2 1st Mar 2007 05:32 PM
Cluster stacked graph AND line combo graph? robotman@gmail.com Microsoft Excel Charting 6 14th Oct 2006 12:33 AM
How do i add a line graph onto a stacked column chart using data =?Utf-8?B?Tmljb2xh?= Microsoft Excel Charting 1 6th Oct 2005 04:03 PM
Stacked bar and line graph as one chart =?Utf-8?B?TEZveA==?= Microsoft Excel Charting 1 11th Nov 2004 03:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:56 PM.