Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help on Excel data auto generation of graph
Hi, Not sure if Excel has this ability to do what I want. Suppose I will have a CSV file file on daily basis, say put it int c:\data\20050101.txt format. Is it possible for Excel to import the csv ( maybe by Macro , or othe way? ) data and plot it in graph on weekly basis for trend provision Pls suggest way that I can start with, thx. Bgds, Do -- gorfongPosted from http://www.pcreview.co.uk/ newsgroup acces |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help on Excel data auto generation of graph
You can open a CSV in Excel by doing file=Open and selecting your file
In VBA workbooks.Open "C:\Data\20050101.CSV" I would suggest you name the file CSV instead of text - otherwise you would have to use the open text method. You could set up a template that already has all the analysis you want set up. then just paste the new data into that template. -- Regards, Tom Ogilvy "gorfong" <gorfong.1s0lub@ wrote in message ... Hi, Not sure if Excel has this ability to do what I want. Suppose I will have a CSV file file on daily basis, say put it into c:\data\20050101.txt format. Is it possible for Excel to import the csv ( maybe by Macro , or other way? ) data and plot it in graph on weekly basis for trend provision? Pls suggest way that I can start with, thx. Bgds, Don -- gorfongPosted from http://www.pcreview.co.uk/ newsgroup access |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help on Excel data auto generation of graph
Excel will open the CSV directly and load the data into a worksheet. Add a
graph by storing the VBA code in your personal.xls if the data is in the same place then use the macro recorder to create the VBA. If the data varies in length then post again with some more information about data and graphics required. -- Cheers Nigel "gorfong" <gorfong.1s0lub@ wrote in message ... Hi, Not sure if Excel has this ability to do what I want. Suppose I will have a CSV file file on daily basis, say put it into c:\data\20050101.txt format. Is it possible for Excel to import the csv ( maybe by Macro , or other way? ) data and plot it in graph on weekly basis for trend provision? Pls suggest way that I can start with, thx. Bgds, Don -- gorfongPosted from http://www.pcreview.co.uk/ newsgroup access |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Numbering certificate generation | Excel Discussion (Misc queries) | |||
Auto-generation of pivot table from XSL stylesheet | Excel Programming | |||
Automatic Graph generation by series | Charts and Charting in Excel | |||
Add-in Auto-Generation | Excel Programming | |||
Auto generation of 3 levels of running number | Excel Worksheet Functions |