Column-line chart on two axes

's Computer Specifications

How do I do this in Excel 2007. There used to be a custom chart in 2003 – is
there still in 2007?

's Computer Specifications

Make a column chart
Select one of the data series in the chart; change Chart Type to Line
Then format it to have secondary axis
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mary Ann" <(E-Mail Removed)> wrote in message
news:786B53A1-2A1D-4386-84F6-(E-Mail Removed)...
> How do I do this in Excel 2007. There used to be a custom chart in 2003 -
> is
> there still in 2007?

's Computer Specifications

Thank you - works a treat!

"Bernard Liengme" wrote:

> Make a column chart
> Select one of the data series in the chart; change Chart Type to Line
> Then format it to have secondary axis
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
> remove caps from email
>
> "Mary Ann" <(E-Mail Removed)> wrote in message
> news:786B53A1-2A1D-4386-84F6-(E-Mail Removed)...
> > How do I do this in Excel 2007. There used to be a custom chart in 2003 -
> > is
> > there still in 2007?
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to change bar to line in line-column on 2 axes chart in Excel2	jaysan3	Microsoft Excel Charting	2	2nd Jul 2008 11:13 AM
Chart Error when using Chart Line - Column on 2 Axes in vba code	=?Utf-8?B?Sm9obg==?=	Microsoft Excel Programming	2	3rd Aug 2007 01:42 PM
How to add a Vertical Line to a Column or Line Chart with two axes already in use?	Alan	Microsoft Excel Charting	6	13th Dec 2006 03:37 AM
chart: line-column with 2 Y axes	=?Utf-8?B?R3JpZmY=?=	Microsoft Access Reports	0	19th Aug 2006 01:51 PM
Line - Column Chart on 2 Axes	Valerie	Microsoft Powerpoint	1	17th Sep 2004 11:51 AM