Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Alternatives for Excel for charting dated time-series?
I need to chart dated time-series using simple line charts. I
recently got a trial of a financial data service, CEIC. It is a breeze. I click on a dated time series, and, hurrah! A graph pops up. I click on the next, and yahoo! Another graph. It makes life easy and fun. I can compare things without endless Excel grunt-work, which is so agonizing. Now, the big question - are there other programs, besides Excel, which could make handling time-series data more fun, more intuitive, easier? Any ideas? What I need to do is so simple - to run a line-graph QUICKLY from a simple time series - and yet Excel makes it such hard work. Excel seems spread-sheet focused, not oriented towards quickly and easily delivering graphical ouput. There must be something else. Anyone have any good experiences? |
#2
|
|||
|
|||
Hi Matthew,
Excel is a spreadsheet program. So, yes, it is spreadsheet focussed. It is a very powerful aplication that allows us to do lots of things. For instance, download this sample http://edferrero.m6.net/Content/ChartSelector.zip to see how you can chart a series just by clicking on one cell. Ed Ferrero "Matthew Pollock" wrote in message m... I need to chart dated time-series using simple line charts. I recently got a trial of a financial data service, CEIC. It is a breeze. I click on a dated time series, and, hurrah! A graph pops up. I click on the next, and yahoo! Another graph. It makes life easy and fun. I can compare things without endless Excel grunt-work, which is so agonizing. Now, the big question - are there other programs, besides Excel, which could make handling time-series data more fun, more intuitive, easier? Any ideas? What I need to do is so simple - to run a line-graph QUICKLY from a simple time series - and yet Excel makes it such hard work. Excel seems spread-sheet focused, not oriented towards quickly and easily delivering graphical ouput. There must be something else. Anyone have any good experiences? |
#3
|
|||
|
|||
Hi -
I've been using a number of programs that do the same sort of thing, and ultimately there isn't one "best". First of all, understand that Excel **is** a spreadsheet. Duh. What you want it to be is a database program that has charting tools built in so that it will automagically do what you want it to do. Excel *can* be close to that: however, Excel is a general purpose tool that has to be programmed to do what it is you want it to do. Then you can make it jump through hoops and ring bells and blow whistles (literally, with access to some machinery and serial ports). But that requires specialized programming work, much of which you can see here. Companies like CEIC and others - disclosu I work for a financial research company that, yes, offers data on-line with those same kinds of tools you are looking for: ours is better, we've over 1 million time series, give me a call! :-) - sell you the service of being able to make a chart Real Fast using their own proprietary tools and databases. That's where they make money. Further, the more specialized you get, the more it costs: if you want to have the figures for production of textile machinery is Estonia, you pay more than if you need to know the exchange rate. But you also get the numbers you need. So you are really looking at rather different systems and tools. On the one hand, Excel is general purpose; on the other hand, you have tools that serve only one purpose. And seriously, we have a great Excel add-in that might well meet your needs *and* a New York branch... John F. Opie Senior Economist Feri Research GmbH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mulitiplying time | Excel Worksheet Functions | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |