Basic Calc/Spreadsheet Questions

[Linda Hull]

Is there a written Tutorial for making charts in AOO 4.1.2? I haven't found
much.

I want to make a pie chart.

I have a list of country names and numbers:
390 CA
337 GB
286 NL
234 DE
 51KR
 46RU
 44EG

Calc appears to handle the CA GB NL as second column of data, but doesn't
know how to assign them values.

I would like the chart to have a key that shows the colors of the segment
and has the Country Code beside it:

[purple] CA
[green] GB
[yellow] NL

Is there a way to rotate the pie, so that I can pick which segments are in
front? Can the colors be changed?

How do I get a title to appear in the Chart? One time it worked. The next
time each word in the title ended up with a color marker by it, like a key;
but I couldn't make it do that again.

Separately:
I've had problems keeping titles at the tops of spreadsheets. When
reopened, they often end up below the table.

I appreciate all your help.

Sincerely,

Linda

Re: Basic Calc/Spreadsheet Questions

[Brian Barker]

At 05:06 12/01/2016 -0500, Linda Hull wrote:

Is there a written Tutorial for making charts in AOO 4.1.2?


Yes: Chapter 3 "Creating Charts and Graphs: Presenting information 
visually" in the Calc Guide. See

https://wiki.openoffice.org/w/images/d/d0/0303CG33-ChartsAndGraphs.pdf .


I want to make a pie chart.


There's a section on pie charts.


I have a list of country names and numbers:
390 CA
337 GB
286 NL
[...]

Calc appears to handle the CA GB NL as second column of data, but 
doesn't know how to assign them values.


You need to swap the order of your columns: to have the labels to the 
left of the values.


I would like the chart to have a key that shows the colors of the 
segment and has the Country Code beside it:

[purple] CA
[green] GB
[yellow] NL


Tick "Display legend" in the fourth step ("Chart Elements") of the 
Chart Wizard.


Is there a way to rotate the pie, so that I can pick which segments 
are in front?


Reorder your data. The segments appear to be presented starting at 
the top and working anticlockwise.



Can the colors be changed?


Yes - at Tools | Options... | Charts | Default Colours.


How do I get a title to appear in the Chart?


Add it in the fourth step ("Chart Elements") of the Chart Wizard.


Separately:
I've had problems keeping titles at the tops of spreadsheets. When 
reopened, they often end up below the table.


Really?

You can create titles by entering them into suitable spreadsheet 
cells - or suitable merged cells. You can also enter a header at 
Format | Page... | Header | Edit... and similarly for a footer. I 
don't see why any of these should move around.


I trust this helps.

Brian Barker - privately


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Basic Calc/Spreadsheet Questions

[Linda Hull]

Brian,

You have always come through with beautiful simple answers that take the
kinks out of doing things.

Thanks so MUCH!

I'll try this when I'm more awake and then I might have more questions.

Have a beautiful day :)

Most sincerely,

Linda

On Tue, Jan 12, 2016 at 6:15 AM, Brian Barker 
wrote:

> At 05:06 12/01/2016 -0500, Linda Hull wrote:
>
>> Is there a written Tutorial for making charts in AOO 4.1.2?
>>
>
> Yes: Chapter 3 "Creating Charts and Graphs: Presenting information
> visually" in the Calc Guide. See
> https://wiki.openoffice.org/w/images/d/d0/0303CG33-ChartsAndGraphs.pdf .
>
> I want to make a pie chart.
>>
>
> There's a section on pie charts.
>
> I have a list of country names and numbers:
>> 390 CA
>> 337 GB
>> 286 NL
>> [...]
>>
>> Calc appears to handle the CA GB NL as second column of data, but doesn't
>> know how to assign them values.
>>
>
> You need to swap the order of your columns: to have the labels to the left
> of the values.
>
> I would like the chart to have a key that shows the colors of the segment
>> and has the Country Code beside it:
>> [purple] CA
>> [green] GB
>> [yellow] NL
>>
>
> Tick "Display legend" in the fourth step ("Chart Elements") of the Chart
> Wizard.
>
> Is there a way to rotate the pie, so that I can pick which segments are in
>> front?
>>
>
> Reorder your data. The segments appear to be presented starting at the top
> and working anticlockwise.
>
> Can the colors be changed?
>>
>
> Yes - at Tools | Options... | Charts | Default Colours.
>
> How do I get a title to appear in the Chart?
>>
>
> Add it in the fourth step ("Chart Elements") of the Chart Wizard.
>
> Separately:
>> I've had problems keeping titles at the tops of spreadsheets. When
>> reopened, they often end up below the table.
>>
>
> Really?
>
> You can create titles by entering them into suitable spreadsheet cells -
> or suitable merged cells. You can also enter a header at Format | Page... |
> Header | Edit... and similarly for a footer. I don't see why any of these
> should move around.
>
> I trust this helps.
>
> Brian Barker - privately
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Basic Calc/Spreadsheet Questions

[Brian Barker]

At 06:47 12/01/2016 -0500, Linda Hull wrote:
You have always come through with beautiful simple answers that take 
the kinks out of doing things.


How kind!


Thanks so MUCH!


No probs!

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Basic Calc/Spreadsheet Questions

[Rory O'Farrell]

On Tue, 12 Jan 2016 05:06:55 -0500
Linda Hull  wrote:

> Is there a written Tutorial for making charts in AOO 4.1.2? I haven't found
> much.
> 
> I want to make a pie chart.
> 
> I have a list of country names and numbers:
> 390 CA
> 337 GB
> 286 NL
> 234 DE
>  51KR
>  46RU
>  44EG
> 
> Calc appears to handle the CA GB NL as second column of data, but doesn't
> know how to assign them values.
> 
> I would like the chart to have a key that shows the colors of the segment
> and has the Country Code beside it:
> 
> [purple] CA
> [green] GB
> [yellow] NL
> 
> Is there a way to rotate the pie, so that I can pick which segments are in
> front? Can the colors be changed?
> 
> How do I get a title to appear in the Chart? One time it worked. The next
> time each word in the title ended up with a color marker by it, like a key;
> but I couldn't make it do that again.
> 
> Separately:
> I've had problems keeping titles at the tops of spreadsheets. When
> reopened, they often end up below the table.
> 
> I appreciate all your help.
> 
> Sincerely,
> 
> Linda

I don't do spreadsheets at other than a trivial level, but I can tell you that 
one can freeze the first rows/columns by positioning the cursor in the first 
row/column one does not wish to freeze and selecting /Window /Freeze.

 
-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org