Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Investing data in a table
I have a list of data, including dates and relevant data, which I have
downloaded from Yahoo. There are over 2,000 rows. I wish to plot the data, with the latest data being on the right side of the graph. However, the data is the "wrong way around", with the result that the oldest data is on the right-side and the newest data on the left-side of the graph. Is there a way that I can "flip" the data around on the chart without having to do it on the table of data? Many thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Investing data in a table
I have designed many financial projects such as this. There may be a better
method but I have used a macro to sortview the graph and then resort. This can be automatic with a sheet activate/deactivate event macro. -- Don Guillett Microsoft MVP Excel SalesAid Software "CEGavinMcGrath" wrote in message ... I have a list of data, including dates and relevant data, which I have downloaded from Yahoo. There are over 2,000 rows. I wish to plot the data, with the latest data being on the right side of the graph. However, the data is the "wrong way around", with the result that the oldest data is on the right-side and the newest data on the left-side of the graph. Is there a way that I can "flip" the data around on the chart without having to do it on the table of data? Many thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Investing data in a table
Format Axis/ Scales/ Values in reverse order.
-- David Biddulph "CEGavinMcGrath" wrote in message ... I have a list of data, including dates and relevant data, which I have downloaded from Yahoo. There are over 2,000 rows. I wish to plot the data, with the latest data being on the right side of the graph. However, the data is the "wrong way around", with the result that the oldest data is on the right-side and the newest data on the left-side of the graph. Is there a way that I can "flip" the data around on the chart without having to do it on the table of data? Many thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Investing data in a table
Don,
Many thankls for your reply. Have a read of David Biddulph's reply. "Don Guillett" wrote: I have designed many financial projects such as this. There may be a better method but I have used a macro to sortview the graph and then resort. This can be automatic with a sheet activate/deactivate event macro. -- Don Guillett Microsoft MVP Excel SalesAid Software "CEGavinMcGrath" wrote in message ... I have a list of data, including dates and relevant data, which I have downloaded from Yahoo. There are over 2,000 rows. I wish to plot the data, with the latest data being on the right side of the graph. However, the data is the "wrong way around", with the result that the oldest data is on the right-side and the newest data on the left-side of the graph. Is there a way that I can "flip" the data around on the chart without having to do it on the table of data? Many thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Investing data in a table
David,
That's perfect. Many thanks. "David Biddulph" wrote: Format Axis/ Scales/ Values in reverse order. -- David Biddulph "CEGavinMcGrath" wrote in message ... I have a list of data, including dates and relevant data, which I have downloaded from Yahoo. There are over 2,000 rows. I wish to plot the data, with the latest data being on the right side of the graph. However, the data is the "wrong way around", with the result that the oldest data is on the right-side and the newest data on the left-side of the graph. Is there a way that I can "flip" the data around on the chart without having to do it on the table of data? Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Investing,Mutual Funds Formula? | Excel Worksheet Functions | |||
Convert Pivot table back to Data Table | Excel Discussion (Misc queries) | |||
convert Pivot table back to Data table | Excel Discussion (Misc queries) | |||
Convert Pivot Table to Normal Data table | Excel Discussion (Misc queries) | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) |