Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 31st 08, 01:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 2
Default Line and a Col on 2 axis in Office Excel 2007

I used the line and col on 2 axis loads in the previous versions of
Excel but can't seem to find it in Office Excel 2007. Any ideas
anyone?

Thanks in advance for your help

Jake

  #2   Report Post  
Old January 31st 08, 01:42 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Line and a Col on 2 axis in Office Excel 2007

Hi,

No combination charts as default in 2007, which is no bad thing.

Create column chart based on both sets of data.
Select the series you want as line on secondary axis.
Change the chart type to line.
Set the Axis to Secondary via the format dialog.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"jake the peg" wrote in message
...
I used the line and col on 2 axis loads in the previous versions of
Excel but can't seem to find it in Office Excel 2007. Any ideas
anyone?

Thanks in advance for your help

Jake


  #3   Report Post  
Old January 31st 08, 09:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 2
Default Line and a Col on 2 axis in Office Excel 2007

On Jan 31, 12:42*pm, "Andy Pope" wrote:
Hi,

No combination charts as default in 2007, which is no bad thing.

Create column chart based on both sets of data.
Select the series you want as line on secondary axis.
Change the chart type to line.
Set the Axis to Secondary via the format dialog.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info
"jakethepeg" wrote in ...



I used the line and col on 2 axis loads in the previous versions of
Excel but can't seem to find it in Office Excel 2007. Any ideas
anyone?


Thanks in advance for your help


Jake- Hide quoted text -


- Show quoted text -


Andy,

thank you very much

All the best

Jake


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 you change the axis label position in office 2007? saxerfone Charts and Charting in Excel 1 January 30th 08 04:06 AM
Office 2007 compatibility pack on Office 2003 (slow network file fox_mulder33 Setting up and Configuration of Excel 0 January 2nd 08 04:28 PM
Opening an Office 2007 Excel file in Office 2003 charstachura Excel Discussion (Misc queries) 1 November 8th 07 10:36 PM
Migrating Office XP EXCEL files to Office 2007 SDR Setting up and Configuration of Excel 0 April 19th 07 02:38 AM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 09:45 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017