PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Re: Newbie: How to I reverse X and Y axis values?

Reply

Re: Newbie: How to I reverse X and Y axis values?

 
Thread Tools Rate Thread
Old 25-09-2003, 03:27 PM   #1
Tushar Mehta
Guest
 
Posts: n/a
Default Re: Newbie: How to I reverse X and Y axis values?


Having the x and y values inadertently exchanged in a chart typically
means that on the worksheet the y values are in a column to the left of
the x values. So, copy/move the y values such that they are in a
column to the right of the x values. Now, select the old x values and
the new y values and then click the chart wizard.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <Os0ywd2gDHA.1340@tk2msftngp13.phx.gbl>, larry@lwoods.com
says...
> I have selected two columns of data. Then I click the Chart icon and select
> a format. I get a chart but the X values and Y values are reversed from
> what I want--and I can't find out how to reverse them. I can only image
> that there is some "simple" way to do this, but I can't find it.
>
> HELP!
>
> TIA,
>
> Larry Woods
>
>
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off