How do I show inverse data in a chart?

's Computer Specifications

I want to show a ranking from 1st place thourgh 10th, where 1st place is the
goal. How can I show this on a chart, so that if I am in 9th place, I am 2nd
to last place?

's Computer Specifications

You can reverse the order of an axis: double click on the axis, click on the
Scale tab, and check the appropriate box.

Alternatively you could put the value you want to plot in another range on
the sheet, and plot that.

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

"debjocc" <(E-Mail Removed)> wrote in message
news:3569405C-5086-4BDF-8A27-(E-Mail Removed)...
>I want to show a ranking from 1st place thourgh 10th, where 1st place is
>the
> goal. How can I show this on a chart, so that if I am in 9th place, I am
> 2nd
> to last place?

's Computer Specifications

If I reverse the order, then the bars appear at the top of the chart and head
downward. What I would really like to show, is that 10 is the minimum, so
that it appears at the bottom of the chart. If my rank is 7th, I would like
to see the bar rising from 10th place to 7th, showing I have 6 more steps to
reach number 1. Is this possible without showing the scale as negative?

"Jon Peltier" wrote:

> You can reverse the order of an axis: double click on the axis, click on the
> Scale tab, and check the appropriate box.
>
> Alternatively you could put the value you want to plot in another range on
> the sheet, and plot that.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> "debjocc" <(E-Mail Removed)> wrote in message
> news:3569405C-5086-4BDF-8A27-(E-Mail Removed)...
> >I want to show a ranking from 1st place thourgh 10th, where 1st place is
> >the
> > goal. How can I show this on a chart, so that if I am in 9th place, I am
> > 2nd
> > to last place?
>
>
>

's Computer Specifications

There's another checkbox near the Plot in Reverse Order, labeled Axis
Crosses at Maximum. Check it.

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

"debjocc" <(E-Mail Removed)> wrote in message
news:E6143010-F56D-49AE-8B31-(E-Mail Removed)...
> If I reverse the order, then the bars appear at the top of the chart and
> head
> downward. What I would really like to show, is that 10 is the minimum, so
> that it appears at the bottom of the chart. If my rank is 7th, I would
> like
> to see the bar rising from 10th place to 7th, showing I have 6 more steps
> to
> reach number 1. Is this possible without showing the scale as negative?
>
> "Jon Peltier" wrote:
>
>> You can reverse the order of an axis: double click on the axis, click on
>> the
>> Scale tab, and check the appropriate box.
>>
>> Alternatively you could put the value you want to plot in another range
>> on
>> the sheet, and plot that.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Peltier Technical Services
>> Tutorials and Custom Solutions
>> http://PeltierTech.com/
>> _______
>>
>> "debjocc" <(E-Mail Removed)> wrote in message
>> news:3569405C-5086-4BDF-8A27-(E-Mail Removed)...
>> >I want to show a ranking from 1st place thourgh 10th, where 1st place is
>> >the
>> > goal. How can I show this on a chart, so that if I am in 9th place, I
>> > am
>> > 2nd
>> > to last place?
>>
>>
>>

's Computer Specifications

So that's the secret! (well, not anymore) Thank you!

"Jon Peltier" wrote:

> There's another checkbox near the Plot in Reverse Order, labeled Axis
> Crosses at Maximum. Check it.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> "debjocc" <(E-Mail Removed)> wrote in message
> news:E6143010-F56D-49AE-8B31-(E-Mail Removed)...
> > If I reverse the order, then the bars appear at the top of the chart and
> > head
> > downward. What I would really like to show, is that 10 is the minimum, so
> > that it appears at the bottom of the chart. If my rank is 7th, I would
> > like
> > to see the bar rising from 10th place to 7th, showing I have 6 more steps
> > to
> > reach number 1. Is this possible without showing the scale as negative?
> >
> > "Jon Peltier" wrote:
> >
> >> You can reverse the order of an axis: double click on the axis, click on
> >> the
> >> Scale tab, and check the appropriate box.
> >>
> >> Alternatively you could put the value you want to plot in another range
> >> on
> >> the sheet, and plot that.
> >>
> >> - Jon
> >> -------
> >> Jon Peltier, Microsoft Excel MVP
> >> Peltier Technical Services
> >> Tutorials and Custom Solutions
> >> http://PeltierTech.com/
> >> _______
> >>
> >> "debjocc" <(E-Mail Removed)> wrote in message
> >> news:3569405C-5086-4BDF-8A27-(E-Mail Removed)...
> >> >I want to show a ranking from 1st place thourgh 10th, where 1st place is
> >> >the
> >> > goal. How can I show this on a chart, so that if I am in 9th place, I
> >> > am
> >> > 2nd
> >> > to last place?
> >>
> >>
> >>
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inverse colors in bar chart	Marcin Peciak	Microsoft Excel Charting	1	23rd Jun 2009 09:02 AM
Show chart data info when hovering over data point	Steve Krieger	Microsoft Access Forms	0	6th Jun 2008 03:15 PM
MS Access report chart - how to show real data, not default data	=?Utf-8?B?S0thbmU=?=	Microsoft Access Reports	1	9th Mar 2005 03:15 PM
How do I change the inverse colour in an Excel chart?	=?Utf-8?B?ZGF2aWRfaHV0dG9uLk5PX1NQQU0=?=	Microsoft Excel Charting	3	21st Feb 2005 12:16 PM
How do I chart part of data but show all data in data table?	=?Utf-8?B?Q0FuZ2Vs?=	Microsoft Powerpoint	2	22nd Oct 2004 11:13 PM