Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - importing windows excel file - running into problems
importing windows excel file - running into problems
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
pdabill
Blue Pill


Joined: Nov 16, 2006
Posts: 1

PostPosted: Thu Nov 16, 2006 5:23 pm    Post subject: importing windows excel file - running into problems

I am new to macs and to neooffice. I am trying to import an excel file that has multiple worksheets. The first worksheet is a chart that displays multiple sets of data (e.g. sales data for company 1, sales data for company 2, etc). The subsequent worksheets contain the sales data for each company. The problem I am having is that the chart only displays the sales data for company 1 and none of the other companies. Does this program have the capability to display multiple sets of data on the same graph?
Back to top
valterb
The Anomaly
(earlier version)


Joined: Sep 23, 2005
Posts: 463
Location: San Giuliano Terme, Pisa, Italy

PostPosted: Fri Nov 17, 2006 12:38 am    Post subject:

Sure you can!!!

Let's say you have 3 sheets with data for the 3 companies (sheet 2, 3 and 4). . All sheets have to be arranged in the same manner: for exapmple data from cell A1 to B10.
If you use the wizard to create the graph references are

$FirstSheet.$FirstCellColoum$FirtCellRow:$LastSheet.$LastCellColoum$LastCellRow

like $Sheet2.$A$1:$Sheet4.$B$10

Hope this respond your request.

Valter
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.