hi, i plotted a chart in excel. now i want to change position of x and y
axis. In the other hand i want to make x axis as y axis and vice versa.
thanks.
hi, i plotted a chart in excel. now i want to change position of x and y
axis. In the other hand i want to make x axis as y axis and vice versa.
thanks.
Select the plotted data. In the formula bar you will see
=SERIES(optional,xrange,yrange,chartnum)
reverse the order of the 2nd and 3rd arguments.
Alternately, when creating the chart, at "Chart Wizard - Step 2 of 4 -
Chart Source Data" select the Series tab and specify the appropriate
ranges as X Values and Y Values.
By default, Excel assumes that the left-most column (or top-most row)
contains the X Values
Jerry
zare-jamal wrote:
> hi, i plotted a chart in excel. now i want to change position of x and y
> axis. In the other hand i want to make x axis as y axis and vice versa.
>
> thanks.
I have a simple utility that works for XY charts:
http://peltiertech.com/Excel/Zips/SwitchXYAxes.zip
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Jerry W. Lewis wrote:
> Select the plotted data. In the formula bar you will see
> =SERIES(optional,xrange,yrange,chartnum)
> reverse the order of the 2nd and 3rd arguments.
>
> Alternately, when creating the chart, at "Chart Wizard - Step 2 of 4 -
> Chart Source Data" select the Series tab and specify the appropriate
> ranges as X Values and Y Values.
>
> By default, Excel assumes that the left-most column (or top-most row)
> contains the X Values
>
> Jerry
>
> zare-jamal wrote:
>
>> hi, i plotted a chart in excel. now i want to change position of x and
>> y axis. In the other hand i want to make x axis as y axis and vice versa.
>>
>> thanks.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks