Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
I cannot make charts with two Y axes anymore
Now that I have Excel 2007, I cannot find the same template as I had
in the previous versions of Excel. I must be missing something. Lines on 2 axes used to be included on the Custom Types menu, but I cannot find it anywhere on the 2007 chart menu. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
I cannot make charts with two Y axes anymore
Hi,
Combination charts are not offered as default chart types in xl2007, which is good. You will need to format the chart your self. Create the chart as a 2 series line chart and then select the series you want displayed on the secondary axis. Once selected use the Format dialog to select Series Options and change Plot Series On to Secondary axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jimbo" wrote in message ps.com... Now that I have Excel 2007, I cannot find the same template as I had in the previous versions of Excel. I must be missing something. Lines on 2 axes used to be included on the Custom Types menu, but I cannot find it anywhere on the 2007 chart menu. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Axes in Charts | Charts and Charting in Excel | |||
dual axes charts, 2 questions.... | Charts and Charting in Excel | |||
charts plotted with data on two axes | Excel Discussion (Misc queries) | |||
Radar charts with independent axes | Charts and Charting in Excel | |||
Setting axes for 3-dimensional charts | Charts and Charting in Excel |