Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Dearest Wizards,
Col A has dates, in order but with most recent toward top. Col D has data to be graphed. What I want is for the resulting graph to have the most recent date on the RIGHT side of the graph (on the X-Axis) and the earliest dates on the LEFT. The order on the spreadsheet really can't be changed to accommodate this. TIA for any help you can give. Sam |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
Double click the X axis and on the scale tab of the format dialog check, Dates in Reverse order To keep the Y axis labels on the left also check Value (Y) axis crosses at maximum value Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Metolius Dad" wrote in message ... Dearest Wizards, Col A has dates, in order but with most recent toward top. Col D has data to be graphed. What I want is for the resulting graph to have the most recent date on the RIGHT side of the graph (on the X-Axis) and the earliest dates on the LEFT. The order on the spreadsheet really can't be changed to accommodate this. TIA for any help you can give. Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I split a y axis in order to display extreme values? | Charts and Charting in Excel | |||
OWC.CHART - Why does my X-Axis come out in the wrong order - somet | Charts and Charting in Excel | |||
Control X axis order | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |