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.
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]
