Hi Rory,

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.

The chart, indeed, interprets cells that do not contain numbers as empty. But what would you expect to show in the chart when a cell contains "car"? This would make only sense, if you would have categories (means of transportation) on the y-axis, which do not exist in the chart.

In the bar chart you would see the distances travelled on the y-axis, where should the means of transportation be displayed?

Regards,
-Bjoern

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to