Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
draw vertical line to mark today in diagram | Excel Discussion (Misc queries) | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
How can I add third axis to the diagram? | Charts and Charting in Excel | |||
reversing the axis on a chart | Charts and Charting in Excel | |||
Graphing Reversing the Axis | Setting up and Configuration of Excel |