Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2nd Vertical Axis and line graph
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vertical Highlighting on line graph??? | Charts and Charting in Excel | |||
Graph - display Category (X) axis in the vertical position | Excel Discussion (Misc queries) | |||
How do I add two vertical scales to a line graph? | Charts and Charting in Excel | |||
Problem adding a vertical line to a graph with months on x-axis | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel |