Home Page

SSuite Office Software

Providers of Safe and Trusted Software with Pure Visual Simplicity

The Art of Charting

It is very easy to create wonderful and informative charts in a spreadsheet. It all comes down to what data you have and how that data is presented in tabular form inside a spreadsheet worksheet.

The following are examples of charting data in general spreadsheet applications.


To start of we will do a simple sinewave graph chart:


Tutorials to make you a better software user.



To create the chart, just select your data from A1 down to B18, press on the chart toolbutton Icon and follow the Charting Wizard. Your result should look like the above chart image.


Now for something more interesting, a Gant Chart:


Tutorials to make you a better software user.


Again, you need only select your data from G2 down to I5. Select the chart button on the toolbar, and follow the Charting Wizard. It could'nt be easier than this.

 

Now for a really hard one, a Histogram:


Tutorials to make you a better software user.

 

To create this chart, you need to select the data range;  H6 down to J15. This will then create a Histogram from your data.

Take a look at the formulas used in I6 to I15, you must use the COUNTIF FUNCTION TO CALCULATE YOUR VALUES, to find the frequency of values in your data column - C5 to C29. Please remember when selecting your data for the Histogram chart, you must include a third empty range instead of just the two. The chart wizard must have more than two ranges selected to work properly.



Enjoy creating your charts...


Click here to view all our free office suite software downloads that are available directly from our servers. Free SSuite Office Software and Suites. Instant LAN video phones and conferencing without an internet connection, instant video lan chat and wifi. Gif Animators, Envelope printer, and Label printers with Avery templates. Click here to view our main page and selection of free office suite software downloads. We have the best free office software and suites including instant video with voip conferencing software and phones for LAN and internet without the need for an internet connection. Standalone voip video and instant messaging software also available. Gif Animators, Envelope printer, and Label printers with Avery templates.