Investing data in a table

  • Thread starter Thread starter CEGavinMcGrath
  • Start date Start date
C

CEGavinMcGrath

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.
 
I have designed many financial projects such as this. There may be a better
method but I have used a macro to sort>view the graph and then resort. This
can be automatic with a sheet activate/deactivate event macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

graphing data only in a certain range 2
Data points on Line graphs 1
Blank Lines Question 2
Bizarre chart behaviour when changing axis cross at points 2
Graph linked with combo boxes 2
Line Graph Excluding 0 Values 6
Creating a chart with varying data value ranges 1
Can blank cells be omitted from graph? 7

Back
Top