2nd Vertical Axis and line graph

I followed the instructions for setting up a 2nd Vertical axis from MS , but
I have no FORMAT DAT command. I wish to plot MPG (Columns) and Pence/mile
(Line Graph) against an X axis of months. I have done it with Works
Spreadsheet without any problems. I am using Excel 2007 from Office Home &
Student 2007.

What Microsoft instruction asks you to use the 'FORMAT DAT' command? Can you
share a reference? In *Excel* there is definitely no such command. Maybe,
you meant 'Format Data Series'?

To do what you want, I would plot both series in a column chart. Then,
select the series you want as a line graph on the secondary axis. With the
series selected, click the Chart Type button and select the appropriate Line
chart. With the Line chart selected, right-click and select 'Format Data
Series.' In there set the series to use the 'Secondary' axis.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"mareng" wrote:

I followed the instructions for setting up a 2nd Vertical axis from MS , but
I have no FORMAT DAT command. I wish to plot MPG (Columns) and Pence/mile
(Line Graph) against an X axis of months. I have done it with Works
Spreadsheet without any problems. I am using Excel 2007 from Office Home &
Student 2007.