Creating and Editing a Chart

[Guest]

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

 

[Jon Peltier]

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