Line Graph: Changing X/Y Axis'

  • Thread starter Thread starter laura.b.hopkins
  • Start date Start date
L

laura.b.hopkins

Can somebody please help to recommend a tutorial or simple directions
on creating a chart in Office 2007 that will show how to create a
simple line chart (2-D is fine) that gives flexibility in flipping the
x and y axis? This seems challenging in 2007...

Thanks.
 
You cannot 'flip' a Line chart. In a Line chart the x axis has category
values and if flipped this would give category values to the y axis which
must have numeric values.
But you can readily flip an XY chart. Click the chart; from the Chart Tools
select Design; Click Select Data; now use Edit. In the Edit dialog, select
the new x-range and the new y-range.
best wishes
 
Well how can you set which data you want on the x axis and the y axis.
When I want numbers with less value(ie smaller numbers) on the y axis,
it never happens.
 
Well how can you set which data you want on the x axis and the y axis.
When I want numbers with less value(ie smaller numbers) on the y axis,
it never happens.
Click to expand...

Choose the data (ie the x's, then the y's) separately. If you get it the
wrong way around (and I usually do the first time :) ) then you can sigh
gently and do it again the other way :)
IIRC, if you have 2 columns it will always assume the x's are first. Worst
case, copy the data elsewhere into the order you want.

HTH.
 
Back
Top