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]
