On Thu, 2005-03-03 at 12:36 +0200, Hylton Conacher (ZR1HPC) wrote: > Hi, > > OOo 1.1.3 Calc charts > > > I have 12 Calc sheets which each has data that must be displayed on a > single chart on sheet 13. > > Let us assume that I need to chart the columns B,J, and K on each of the > twelve sheets up to line 33 ie b1:b33 et al. The 12 resultant graphs > must reside on a single chart on a separate sheet(13) so I can see how > each compared with each other. > > I would assume that I would just need to specify the chart range for > each of the 12 sheets ie Jan.B1:B33;Feb....;Mar.....;April.... etc but > it does not work. > > How can I accomplish this?
Working with multiple sheets and cross sheet references is covered in the user guide. See http://tinyurl.com/5u8bt Hope this gives you what you need. -- Documentation Co-Lead PLEASE - keep list traffic on the list. Email sent directly to me may be ignored utterly. "Dinna meddle wi' things ye ken nuthin' aboot!" J.Herriot --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
