Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Reversing only the vertical axis in a diagram

In an excel-document I have data that generates a diagram in another document.
These data have to be put in with the newest information on top so that one
just put in new sheet rows with new data, and after that one can mark a new
area from which the diagram should be generated.
When the data is in this order the diagram is generated so that the newest
data is to the left and the oldest data is to the right, but I would like it
to be in the other way (the newest data always to the right).
I have tried to mark the diagram area and click on Chart Tools - Format -
Plot Area and chosen vertical (value) axis, chosen Format Selection. Here I
have clicked the "values in reverse order"-box.
This changes both the vertical and the horizontal axis, and this is not what
I want. The horizontal axis should always be on the left.
So - how do I do to just reverse the vertical axis (along with the staples
of course).

Thank you in advance for your help

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
draw vertical line to mark today in diagram Florian Demmer Excel Discussion (Misc queries) 1 January 22nd 08 02:31 PM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 09:45 PM
How can I add third axis to the diagram? nemeza Charts and Charting in Excel 2 December 9th 05 03:22 PM
reversing the axis on a chart Chris Strug Charts and Charting in Excel 2 October 18th 05 03:59 PM
Graphing Reversing the Axis Michael R Middleton Setting up and Configuration of Excel 0 November 30th 04 11:59 PM


All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"