Solved

How to create nice looking bar graphs using a text file as input?

Posted on 2010-09-17
8
1,227 Views
Last Modified: 2012-05-10
How to create nice looking bar graphs using a text file as input?

Originally we'll have some raw data (results of calculations) in a two column table.
The idea is to use a text file with all these values, separated by commas, as input. The output would be bar graphs including title, in a picture format such as PNG or JPEG.

Can anyone recommend me any software or an easy way to implement this?
Thanks!
0
Comment
Question by:isoq
8 Comments
 
LVL 32

Expert Comment

by:phoffric
ID: 33699356
You have a text file where each row is of the form:data1,data2...If you have Microsoft Excel, then you can import this file as a Comma Separated Variable file, and the two text columns will fill into two Excel columns. From this you can create your nice bar graphs. You can then right click on the chart and copy and paste it into paint. Now you can save it in PNG or other formats.
0
 

Author Comment

by:isoq
ID: 33699467
Hi, Thanks.
Actually what I need is something that automatically use the CSV file as input, and create the picture as output.
Any idea?
0
 
LVL 6

Accepted Solution

by:
LeeeRussell earned 300 total points
ID: 33699502
You could automatically do this in Excel.  You could write a macro that will automatically generate a graph.  The macro you use will depend on how "Automatic" you require the process to be.

Microsoft have a set of pages on creating graphs in Excel using VBA:

http://msdn.microsoft.com/en-us/library/aa203725(office.11).aspx


If you really don't want to use Excel, the I suspect that there are graphing tools out there you could pay for that would take a CSV file as an input, but it's not an area I've ever investigated.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 32

Expert Comment

by:phoffric
ID: 33699541
Or, you can write a C/C++ program using OpenGL. Reading CSV file is easy.
0
 
LVL 33

Expert Comment

by:Norie
ID: 33709413
If you do want to use Excel the steps are pretty straightforward.

1 Open file.

2 Create chart using data from file as source.

3 Save file in required format.

All of this can be done in VBA, and can be as 'automatic' as you need/want.

It could also be done in a lot of other programming languages using the same basic algorithim.

Obviously you would need some sort of method of creating a chart but most languages have plenty of ways of dealing with file input/ouput.
0
 
LVL 8

Expert Comment

by:twohawks
ID: 33740403
I bet this would make a nice little php project (php bar graphs using GD).
Using PHP with your csv (flat file database) or  mySQL as the data container...
Create a form for input,
Use php to store info in csv or mySQL
Retrieve with php generating bargraph into web page.

Alternatively...
-------
It would undoubtably be something fun to do with Flash, but I have no suggestions for basis for going about it there.  
I think this might be something in that ilk though...
http://active.tutsplus.com/tutorials/xml/create-a-dynamic-bar-graph-generator-using-xml-as3/

------
Or how about Google Charts Tools ?? ;^)

Cheers ;^)
0
 
LVL 27

Expert Comment

by:CaptainCyril
ID: 33767659
If you can convert the file to a string then you can use this:

http://code.google.com/apis/chart/
0
 

Author Closing Comment

by:isoq
ID: 33802761
Good suggestion
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How many squares are in this diagram? 19 9,939
why call someone by this name? 11 323
I smell burning 14 268
specialEleven  java challenge 10 161
Most MSPs worth their salt are already offering cybersecurity to their customers. But cybersecurity as a service is wide encompassing and can mean many things.  So where are MSPs falling in this spectrum?
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question