Rory Walsh wrote:
By the way, if I do this, which makes the chart look much clearer, how
do I specify that the range no longer goes from say $A$1:$N$29 but the
range is A1-to-A29, C1-to-C28, E1-to-E29 and so on? The problem is that
my chart legend now includes those cells that contain the means of
transport.
In this case just select the cells that should be in the chart (using
cltr-left-mousekey) including the title cells before you call "Insert/
Chart". The Range field in the first page of the "Autoformat
chart"-AutoPilot will show something like
$Sheet1.$A$3:$B$5;$Sheet1.$D$3:$D$6;... than.
Kind regards,
Bernd Eilers
Rory.
McGuinness, Brian B C-E LCMC SEC Lockheed wrote:
I would insert a new column after each week column and use the new
columns to hold the means of transportation. For example:
Week1 Week2
Mon 4 Car 6 Bicycle
Tue 2 Train 4 Car
Wed 5 Plane 3 Car
Thursday 2 Bus 2 On foot
Friday Car 5 Rickshaw
--- Brian
-----Original Message-----
From: Rory Walsh [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07,
2006 9:27 AM
To: [email protected]
Subject: [discuss] non-numeric data in calc chart....
Hi everyone. I have a bar chart to plots distances travelled each day
over a set week, for example
Week1 Week2 Week3 Week4...
Mon 4 6
Tue 2 4
Wed 5 3
Thursday 2 2
Friday 5 6
What I would like to do is to somehow insert in each cell the means
of transport, car, plane, bicycle etc. If there any way I can do
this, it seems that whenever I put in any non-numeric value Cacl
treats the cell as empty? Thanks in advance.
Rory.
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
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]
