Home | Hardware | Internet News |Web Hosting |IT Management |Network Storage
LinuxPlanet
Search 
  Power Search | Tips 

 Front Door
 Discussion
 LinuxEngine
 Opinions
 Reports
 Reviews
 Tutorials
 News
 Technology Jobs

 Browse by subject.
Free Newsletter

Java/Open Source Daily
Linux Today
More Free Newsletters

Be a Commerce Partner


















internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

Print this article
Email this article

   LinuxPlanet / Tutorials







Using Impress-ive Charts In OpenOffice.org
Collect, Organize And Build The Chart In Calc

Rob Reilly
Monday, July 19, 2004 11:06:47 AM

The first step to putting a chart into a slide in Impress is to collect your data and get it in a form that can be used. Most people use a spreadsheet to organize their production, sales and profit data. You can use OpenOffice.org Calc for your spreadsheet needs. I've put together some fictitious sales data from three sales professionals at Mega Manufacturing Inc.

Open up a new spreadsheet in Calc, then highlight and copy the following table in your browser. Paste the data into your spreadsheet.

 BobEricBrenda
January10000900013500
February12000920014200
March9000975013000
April125001000011000
May97501000010000
June13000110009200
July 110001200012700
August100001250010000
September92001270012000
October12700130009000
November135001350012500
December14200142009750

Once the data is in your spreadsheet, highlight your data again and click the Insert and Graph buttons. Follow these steps to create a graph:

  1. In the AutoFormat Chart window make sure the "first row as label" and 'first column as label" boxes are checked. When you are done, click the Next button.
  2. In next window you can select the chart type. Scroll down in the chart type window and find the "Lines" 3-dimensional chart. It's a 3-D chart that has ribbon like lines, that show the data. You can use one of the other charts, if you like. This one gives a high-impact visual chart that looks good in the Impress slide.
  3. Select the chart type and make sure the "data in columns" box is checked. Click Next. In the "choose a variant" window, just click Next.
  4. In the Display window you can edit the chart title. Type in "Mega Manufacturing - Sales for 2003" and click Create.

Magically, your 3-D chart will appear on your spreadsheet. You can resize the chart window, change the colors and so on. Left click on the chart, then right click to get a menu of items that can be changed. If you want to edit it on your slide, guess what? You can change it there, too.

Next: Place The Chart On Your Impress Slide »

Skip Ahead

1 Remember That Job With A Process
2 Collect, Organize And Build The Chart In Calc
3 Place The Chart On Your Impress Slide
4 Tweak Your Chart For Your Theme, Colors, Etc.
5 Production Tips For The Pro Presenter





Linux is a trademark of Linus Torvalds.


internet.com home | search | help! | about us

Jupiter Online Media

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Web Hosting | Newsletters | Tech Jobs | Shopping | E-mail Offers