Brian, what a wonderful response. Elchanan -----Original Message----- From: Brian Barker [mailto:[EMAIL PROTECTED] Sent: Friday, November 23, 2007 1:49 PM To: [email protected] Subject: Re: [users] Labels from other row then data
At 18:07 23/11/2007 +0200, Rafal, Maj wrote: >how can I easily in chart take column G for the >labels, and columns B,C,D for data? There are a few workarounds: o Design your spreadsheet with your chart needs in mind, so that the relevant columns are in the right order when you need them. o Copy the relevant columns into another area of the sheet - or even, more conveniently, on another sheet of the same document - and reorder the copied columns to suit the needs of the chart. Define a print range to exclude the copied columns. o Insert a new column before column B, so that your label values are now in column H and the data in C, D, and E. Copy the new column H into the new column B. Create your chart from columns B, C, D, and E, with column B forming the labels. Hide column B. The new column will now neither be displayed nor printed: the appearance of both the screen and the printed page will be what you need. I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
