Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default how does one plot a line-column on two axes in excel?

How does one use Excel 2007 to plot a line and a bar graph with two axes -
the same chhart offered in Excel 2003 under Custom Types?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default how does one plot a line-column on two axes in excel?

Hi,

You have to build the combination chart yourself.
Create a column chart based on both data sets. Select the column you want as
a line and use Change Chart Type to set it to line chart.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"gbrunnhoeffer" wrote in message
...
How does one use Excel 2007 to plot a line and a bar graph with two axes -
the same chhart offered in Excel 2003 under Custom Types?


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 to add a Vertical Line to a Column or Line Chart with two axes already in use? Alan Charts and Charting in Excel 6 December 13th 06 03:37 AM
Combination chart - Line - Column on 2 Axes Debbie Charts and Charting in Excel 2 November 16th 06 09:04 PM
How do you select line or columns in "Line-Column on 2 axes" graphs? mizterbusy Excel Discussion (Misc queries) 0 September 19th 06 06:48 AM
Line-Column 2 axes Help kp Charts and Charting in Excel 1 April 28th 06 12:34 AM
Line - Column 2 Axes chart question mktg@vzw Charts and Charting in Excel 1 March 14th 06 09:22 PM


All times are GMT +1. The time now is 07:24 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"