I would like my graph to shows values in ascending order
on the x-axis. I know how to do this manually however as
the values change on a weekly basis I would like the
graph to autoimatically do this for.
regards Ant
I would like my graph to shows values in ascending order
on the x-axis. I know how to do this manually however as
the values change on a weekly basis I would like the
graph to autoimatically do this for.
regards Ant
You can do this on an XY chart. On the format axis menu, you can change
the scale to display the values in reverse order. If you are using
something besides an XY chart, please let us know.
"[email protected]" <[email protected]> wrote in
message news:[email protected]...
> I would like my graph to shows values in ascending order
> on the x-axis. I know how to do this manually however as
> the values change on a weekly basis I would like the
> graph to autoimatically do this for.
>
> regards Ant
>
Hi,
thanks for the reply but when I chnged the scale to
display values in reverse order the chart I'm using
displayed the same information only upside down. Am I
doing something wrong?
Cheers Ant
>-----Original Message-----
>You can do this on an XY chart. On the format axis
menu, you can change
>the scale to display the values in reverse order. If
you are using
>something besides an XY chart, please let us know.
>
>"[email protected]"
<[email protected]> wrote in
>message news:[email protected]...
>> I would like my graph to shows values in ascending
order
>> on the x-axis. I know how to do this manually however
as
>> the values change on a weekly basis I would like the
>> graph to autoimatically do this for.
>>
>> regards Ant
>>
>
>
>.
>
Anthony -
Did you format the right axis? What's the data look like? Remember, if you change
the order on the X axis, the shape of the plotted data will change.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
[email protected] wrote:
> Hi,
> thanks for the reply but when I chnged the scale to
> display values in reverse order the chart I'm using
> displayed the same information only upside down. Am I
> doing something wrong?
>
> Cheers Ant
>
>
>>-----Original Message-----
>>You can do this on an XY chart. On the format axis
>
> menu, you can change
>
>>the scale to display the values in reverse order. If
>
> you are using
>
>>something besides an XY chart, please let us know.
>>
>>"[email protected]"
>
> <[email protected]> wrote in
>
>>message news:[email protected]...
>>
>>>I would like my graph to shows values in ascending
>
> order
>
>>>on the x-axis. I know how to do this manually however
>
> as
>
>>>the values change on a weekly basis I would like the
>>>graph to autoimatically do this for.
>>>
>>>regards Ant
>>>
>>
>>
>>.
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks