| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create 2-Axis Combination Chart XL 2007
In Excel 2007, there does not appear to be a chart type for combination
charts. I an trying to create a line-bar chart with the line on the left vertical axis and the bar on the right vertical axis. -- t2 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Create 2-Axis Combination Chart XL 2007
Hi,
Microsoft has remove the Custom Types option, however you can still do it manually. 1. Create a line of column chart with your two data sets. 2. Right-click one of the series and choose Format Data Series and on the Series Options tab check Secondary. Click Close. 3. With one of the series selected choose Chart Tools, Design, Change Chart Type and pick a line. If this helps, please click the Yes button Cheers, Shane Devenshire "t2fulham" wrote: In Excel 2007, there does not appear to be a chart type for combination charts. I an trying to create a line-bar chart with the line on the left vertical axis and the bar on the right vertical axis. -- t2 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Create 2-Axis Combination Chart XL 2007
Spectacular. Not exactly intuitive, but just the ticket.
Thanks. -- t2 "Shane Devenshire" wrote: Hi, Microsoft has remove the Custom Types option, however you can still do it manually. 1. Create a line of column chart with your two data sets. 2. Right-click one of the series and choose Format Data Series and on the Series Options tab check Secondary. Click Close. 3. With one of the series selected choose Chart Tools, Design, Change Chart Type and pick a line. If this helps, please click the Yes button Cheers, Shane Devenshire "t2fulham" wrote: In Excel 2007, there does not appear to be a chart type for combination charts. I an trying to create a line-bar chart with the line on the left vertical axis and the bar on the right vertical axis. -- t2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you create combination charts (line-coulmn) in excel 2007? | Charts and Charting in Excel | |||
| Assigning A Value Axis to a Data Series in a Combination Chart | Setting up and Configuration of Excel | |||
| How do I do a combination STACKED column and line chart on 2 axis | Charts and Charting in Excel | |||
| How to create a combination chart? | Excel Worksheet Functions | |||
| How do you make a combination chart with 2 axis. | Charts and Charting in Excel | |||
Hybrid Mode
