Submitted by jan_rifkinson on 2013/06/23 12:43
But anyway, here's the need
 
On my phone (& my wife's phone) we are keeping track of what we spend daily so we can see where it goes & where we might trim. 
The program is very simple which I like.  goo.gl/q4xhY

Enter a number, it automatically adds today's date & offers categories & note
It then immediately converts that data into a line graph (very neat)
I can export data to csv file
 
Question:
I'd like to merge our two files & represent spending graphically
Can IQ do this?

Comments

I suggest using Excel, which can link to csv files.
 
The steps could be:
  1. Export from your CSV files from both phones. If to a dropbox or a GDrive folder, skip step 2
  2. Copy files to PC
  3. Create an Excel file
  4. In Excel 2003, do Data > Import External Data > Import Data
  5. Select the csv file
  6. Use the wizard to import the data
  7. Immediately to the right of the imported range, do the same with the second csv file
  8. Create the chart from the 2 sets of imported data
To update, repeat steps 1, 2 and right click on the imported data sets and select Refresh data. You can set the data range properties to auto-update when opening files. This would make updating a breeze !
 
HTH
 

jan_rifkinson

2013/06/29 17:20

Permalink

Thank you VERY MUCH, Pierre. Tips for Exel.....That's really going above & beyond. Much appreciated.