?
Solved

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

Posted on 2010-09-17
8
Medium Priority
?
1,265 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 33

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 900 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
Worried about phishing attacks?

90% of attacks start with a phish. It’s critical that IT admins and MSSPs have the right security in place to protect their end users from these phishing attacks. Check out our latest feature brief for tips and tricks to keep your employees off a hackers line!

 
LVL 33

Expert Comment

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

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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Lotus Notes is the most prominent choice of all users due to its advance email management. It provides email features along with contact management, appointments, task, calendar etc. Many users rely on its service to carry out electronic communicati…
The most emerging queries of the user is to upload Outlook OST mailboxes to Office 365 account. So, here we will provide the manual as well as an automated solution for to transfer OST file to MS Office 365 in an absolute manner.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Watch the software video of Kernel Import PST to Office 365 tools which can easily import PST and OST files to Office 365 for bulk mailboxes. The process of migration is simple and user can map source and destination mailboxes and easily import data…

569 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