LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Elwood
 
Posts: n/a
Default need help charting a time progression for investments

Here's the data that I have:

A B C D 1
Investments Initial current purchases
-----------------------------------------------------------
2 BigCorp1 9681.03 11108.07 10-21-04
3 Another1 7761.28 8914.30 10-21-04
4 Oboy1 5564.50 6789.10 2-5-05

What I need to show is, for each investment, to show the change (up or
down), and across the X-axis, to show the time passed. So, for
example, I can see that the person bought BigCorp1 on 10-21, and it's
grown n-amount, and they bought Oboy1 on 2-5, and it's grown n-amount,
etc.

Is there a way to do this in one chart? I'm lost as to what data
series(s) to select and how to set it up. Any help would really be
appreciated!

Thanks,
E
 
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
Time sheets Driver Excel Worksheet Functions 5 November 7th 05 11:19 AM
Charting Run Times Nick Junod Charts and Charting in Excel 3 October 31st 05 02:37 AM
Adding time damezumari Excel Discussion (Misc queries) 2 June 20th 05 08:35 PM
Time Sheet Calculation Help Needed! sax30 Excel Worksheet Functions 2 April 26th 05 08:08 PM
Charting time? help please... Gustavo Monteverde Charts and Charting in Excel 1 November 28th 04 04:53 AM


All times are GMT +1. The time now is 06:03 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"