I have downloaded the trial version of MS Office 2007.I have created a chart
of train schedules,but the time and distance on the chart are on the vertical
and horizontal axis respectively.I want to switch these so that the time is
the horizontal axis and distance the vertical axis.Plus the times listed on
the vertical axis are different than the schedule on the worksheet.How can I
edit these?

The other question I have concerns chart size.What are the limits of the
chart's vertical and horizontal axis?

Thanks.

Bill B

You need to set up your data so the X variable is in the left column and the
Y variable in the right, before making the chart. If you don't want to spend
ten seconds to recreate the chart, you can switch the X and Y ranges in the
Source Data dialog. Right click the chart and select Source Data, select the
series in the list on the left, click the Edit button, and swap the contents
of the X and Y boxes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"billb" (donotspam) wrote in message
...
I have downloaded the trial version of MS Office 2007.I have created a
chart
of train schedules,but the time and distance on the chart are on the
vertical
and horizontal axis respectively.I want to switch these so that the time
is
the horizontal axis and distance the vertical axis.Plus the times listed
on
the vertical axis are different than the schedule on the worksheet.How can
I
edit these?

The other question I have concerns chart size.What are the limits of the
chart's vertical and horizontal axis?

Thanks.

Bill B