Samisite Webmaster Community Forum

General Category => General Discussion => Topic started by: lizzieanddarcy on April 02, 2008, 02:54:19 PM

Title: Bar graphs and Tables
Post by: hidden on April 02, 2008, 02:54:19 PM
Hello all,
I need to create a series of bar graphs and tables, which I will need to periodically update with new data, and am trying to determine what would be the best way to do that. I have looked into using Excel, QuatroPro or PowerPoint to design the graphs and tables and then insert them as objects. Is there a software program that works well with CuteSite. I know that CuteSite can make tables, but I need the bar graphs as well, and would like them to have the same look, so I am leaning toward using one program to make both. I am also not tech savvy, so I need something that will be simple. Any ideas?
I appreciate your help!
Thanks,
Lizzieanddarcy
Title: Re: Bar graphs and Tables
Post by: hidden on April 02, 2008, 03:27:59 PM
Any software that can export a graphic will work:  png, jpg, gif are your best formats, bmp will work but is larger than you want.

Then if you need to update them often, your fastest way to do that is use a piece of code.
- Store your images on your website in an images or graphs folder.
- Use FTP software or your website control panel to upload the images where you want them.  Read about FTP on this thread. (http://samisite.com/forum/index.php?topic=240.0)
- Instead of loading the image into CSB by INSERT > PICTURE, you would put your CODE in using INSERT HTML box, pointing to a specific image. 

Code: [Select]
<IMG SRC="/images/graph1i.gif" border=0 alt="description here" title="same description here">
- Once your code is in place in your web pages, every time you re-upload the images to the folder on your site, all your web pages that pull in those images will be updated!  No editing in CSB unless you want to ADD a new picture or point to a different one!  VERY FAST to update.  Just replace your current graph1.jpg with a new graph1.jpg and bingo, your web page will do that!

You can also visit a CSB site that uses this technique to update a few hundred graphs every day/week!!!  He uses Excel for some things and a stock analyzer for others.
His SILVER page is quite popular.  Check out his graphs for silver here. (http://www.investmenttools.com/futures/metals/index.htm)

You can read about this technique on this page. (http://www.samisite.com/photo/id136.htm) (Do not use the container page with captured resource in YOUR situation)