#1   Report Post  
Posted to microsoft.public.excel.misc
glenlee
 
Posts: n/a
Default 3-D column graph

I have data showing sales and % quota attainment by month. I want to
create a 3-D column graph that plots the sales on the column graph
and the % attainment on an overlay line graph. How do I do this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope
 
Posts: n/a
Default 3-D column graph

Hi,

Short answer is you can not create combination 3d charts.
You will need to use 2d column and line.

Cheers
Andy

glenlee wrote:
I have data showing sales and % quota attainment by month. I want to
create a 3-D column graph that plots the sales on the column graph
and the % attainment on an overlay line graph. How do I do this?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i multiply two columns edgar Excel Worksheet Functions 7 March 2nd 06 03:29 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
combination x-y scatter and column graph David Charts and Charting in Excel 5 December 11th 05 06:49 PM
How do you combine a stacked column and single column graph? Charlotte C Charts and Charting in Excel 1 December 3rd 05 01:04 PM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"