[prev in list] [next in list] [prev in thread] [next in thread] 

List:       openoffice-users
Subject:    RE: [users] OpenOffice Calc
From:       "John McAtee" <jlm40 () psu ! edu>
Date:       2003-05-28 17:46:02
Message-ID: 000001c32541$02126dd0$e228ba92 () MACE
[Download RAW message or body]

I was able to create a chart from disconnected rows, I assume the same will
be true about columns.  Here's how I did it:

1 I selected the rows that had the labels (row 1) and data (row 3)
2 I clicked on the Insert Object button on the Main Tool Bar and then
clicked on the Chart button.  This turns the pointer into the chart drawing
tool.
3 Since I wanted the chart on a separate page I changed to the blank page.
4 I clicked and dragged out a rectangle for the chart.  This starts the
AutoFormat Chart AutoPilot.
5 Because I was using data in rows I clicked on the check box "First row as
labels".  I assume that clicking the "First column as labels" box will do
the same thing for columns. Then "Next"
6 I picked the column chart type.  I made sure that the "Data Series in:"
said "columns" because the labels for the data shared the same columns. Then
"Next".
7 I picked the Normal chart variant.  Then "Next"
8 I typed in a Title, unchecked the "Legend" box because I did not want a
legend, then "Create".
9 I clicked on the change data arrangement button so the labels would show
up at the bottom of the chart
10 I double clicked the data labels to reformat them by changing to a small
font, rotated them 90 degrees, in "Text Flow" area I picked "Overlap"


To change the color (or colour) of the bars just double click on the one you
want to change and in the "Data Point" dialog box click on the "Area" tab
then pick your colour (or color).  When you are done click "OK".

That should do the job.

I will admit that it took me a little while to figure it out.  I, too, am
very used to Excel and I was trying to do it the M$ way and got frustrated.

John L. McAtee
jlm40@psu.edu

-----Original Message-----
From: CPH [mailto:cphennessy@openoffice.org] 
Sent: Tuesday, May 27, 2003 5:17 PM
To: users@openoffice.org
Subject: Re: [users] OpenOffice Calc


On Tuesday 27 May 2003 14:05, laurent.duperval@microcell.ca wrote:
> One thing I find is much more powerful in Excel than in Calc is the 
> graphing function. Here are some things that Excel supports that Calc
> doesn't:
>
> - disconnected data columns. For example, you can have your label in
column
>   A and your data in columns C, D and F
>
> - Better configuration: with Calc, you get whatever the developers 
> deemed to be adequate colors. So the sequence is something like Blue, 
> Red, Green, Yellow, etc. If you want higher contrast colours or if you 
> want a different sequence of colours, you're stuck
>
> - I find it easier to modify charts after the fact in Excel than in 
> Calc
>
> There's probably more, but I can't think of anything off the top of my 
> head.

Have you verified that Calc is not implementing these features ? Or have you
requested these features for OOo 1.2 / 2.0 ?

CPH

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.org
For additional commands, e-mail: users-help@openoffice.org



[prev in list] [next in list] [prev in thread] [next in thread]