On 3/27/06, Franck DAUMAS <[EMAIL PROTECTED]> wrote: > > Hi, > > I would to send this e-mail in order to ask why i can't put the the chart > in > the separate sheet in openoffice calc. > > Ideed, I have tryed to import from the (Hiak) Microsoft.exel one > spreadsheet > with a chart in the separate sheet. After that, I get a empty sheet with a > column up side down. > > Could you help me, by advance I thank you... > > A happy office user. > > Best regards > > Franck > > _________________________________________________________________ > http://desktop.msn.fr/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > Franck,
Do you see the frame for the chart at all? If you do, you should be able to right-click on the chart and select "Modify Data Range...". Then in the Range field type in the full description of the data range to use. e.g. If you have two sheets, imaginitively called Sheet1 and Sheet2, with the data in Sheet1 in A1:B10 and the chart in Sheet2, use: $Sheet1.$A$1:$B$10 to set the new range and then click the "Create" button to change the chart. HTH, Simon
