|
Number
|
Question
|
Date
(dd/mm/yy)
|
Length
|
|
|
|
|
|
|
1338
|
This articles collects our notes which shows some of the differences between OpenOffice.org 1.x.x Calc and Microsoft Excel. Knowing about differences may assist if a person is looking to migrate to OpenOffice.org.
|
22/08/05
|
14051
|
|
1005
|
I can produce a bar chart in OpenOffice.org Calc, but I would like a histogram. The histogram has to have no spaces between bars. How do I do this?
|
22/08/05
|
523
|
|
817
|
How do I include only some of the rows or columns of data in my Calc Chart?
|
22/08/05
|
1718
|
|
816
|
I have added a new row of data which is used to create a Chart in Calc. How do I change the Chart to include the new row of data?
|
22/08/05
|
1937
|
|
504
|
How do I change the colour of a column in Chart?
|
22/08/05
|
1432
|
|
501
|
How do I create a Chart in Calc where I have some columns in the chart range which I don't want to display.
|
22/08/05
|
1510
|
|
342
|
How can I add or hide columns or series in Chart?
|
22/08/05
|
470
|
|
293
|
I have data in the form Date, Time and Number which I want to chart. I want to use the Date and Time together as the X axis but Chart does not let me use multiple columns for an axis.
|
22/08/05
|
481
|
|
271
|
When I create a pie chart the percent values are shown in two decimal places and I don't want any decimal places.
|
22/08/05
|
380
|
|
233
|
Chart seems to pick whatever column it likes as the X-Axis. Is there anyway I can nominate which column I use as the X-Axis?
|
22/08/05
|
969
|
|
228
|
I have a table in my spreadsheet which consists of two rows. The first row has text entries and the second row has values associated with the text entries. The text entries in the first row can appear in any column and have multiple occurrences. I want to take all the occurrences of a particular text entries, get the corresponding value in the next row and graph the result. Any suggestions on how I can do this?
|
22/08/05
|
1319
|
|
227
|
I want to draw a chart with columns showing the average values and a line above the columns showing the maximum values. Can I do this in chart?
|
22/08/05
|
481
|
|
226
|
I'm a bit confused on how hlookup and vlookup work and the helps screens don't make it clear. I have a table with a row of fields and below these fields is the value I want to obtain. Can I also use these functions in the chart data range.
|
22/08/05
|
2570
|
|
186
|
How can I change the default colours in a graph?
|
22/08/05
|
91
|
|
167
|
I want to be able to swap the X and Y axis for a chart.
|
22/08/05
|
280
|
|
165
|
I want to be able to change the settings for Chart but I don't seem to be able to do this without recreating the chart. Any suggestions?
|
22/08/05
|
570
|
|
164
|
How do I change the legend in Chart? It simply states it is columnx.
|
22/08/05
|
335
|
