Thanks Bernd, I just tried it and your suggestion works perfectly.
Rory.
Bernd Eilers wrote:
Rory Walsh wrote:
Hi everyone.
Hi there!
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.
You can use User-Defined Cell Formats and Styles for that.
Do the following:
Select the first cell that should be shown as "by bicycle" for example.
Call "Format-Cell"
Select tab page Numbers
On this tab page select the Category "User Defined"
and in the "Format code" box enter the following String
0 [$(Bicycle)]
if you want to show eg. one digit after the comma use
0,0 [$(Bicycle)]
instead
Now click on the "Styles and Formatting Icon" the icon on the left
beneath the Font box.
In the "Styles and Formatting"-Window first select "All Styles" in the
listbox at the botton than
click the "New From Selection" icon ( the one in the middle on the right
side ).
A dialog box appears where you can enter the style name, use "Bicycle".
Now you should have a new Entry "Bicycle" in the styles list of the
"Styles and Formatting"-Window.
Select each cell that also is a "Bicycle" Cell and double click on that
"Bicycle" entry in the list of the "Styles and Formatting"-Window.
Now do similar for the other means of transport.
If you create a bar chart from that now there is some extra trick needed
so that the axis where the values are shown does not show (Bicycle) or
(Car) for all values:
Double click on the chart so that it gets into OLE Inplace Mode and you
the the Chart Menu instead of the Calc Menu.
Select Format/Axis/Y-Axis (assuming you have these values shown on the
Y-Axis, otherwise use X-Axis).
Select the tab page "numbers" uncheck the checkbox
"[x]use source format" Select Category Number and Format "Standard" or
whatever Format suits your needs best and click OK.
Of course you can also use a "User Defined" Format there as an
alternative and use eg. something like
0 [$miles]
as the format string.
Kind regards,
Bernd Eilers
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]
