Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to you change the axis label position in office 2007? | Charts and Charting in Excel | |||
Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
Opening an Office 2007 Excel file in Office 2003 | Excel Discussion (Misc queries) | |||
Migrating Office XP EXCEL files to Office 2007 | Setting up and Configuration of Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel |