Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


There is no problem with the Heading. The problem is with the Headings that
are at the bottom of each column.  They seem to be unmovable.  Anyhow what
is use as a Heading for the column is tricky.  If X12 (any letter before
any number) is a column heading the column heading under the column will be
just the 12.  If a space is put between the X and the 12, the column
heading will be X 12.  I can not figure out how to manage the column
heading.
When the column heading are too long to fit below the columns, and
something is set properly, the heading we be in alternating rows so they
can be read.  If the settings are not set properly the heading will be in
just one row and can not be read.

On Fri, Dec 23, 2011 at 4:53 PM, Tom Davies <tomdavies04@yahoo.co.uk> wrote:

Hi :)
I think you can move the heading.  Can you click into the chart somewhere
and then imagine a frame around the heading and try to click on it?  Once
you have found and selected the frame it should be fairly easy to drag it
somewhere.
Regards from
Tom :)

--- On Fri, 23/12/11, Walter Hildebrandt <wh9991@gmail.com> wrote:

From: Walter Hildebrandt <wh9991@gmail.com>
Subject: Re: [libreoffice-users] Chart in Calc
To: users@global.libreoffice.org
Date: Friday, 23 December, 2011, 17:24

Yes Tom, something is a bit wondy (As an American I do not know the true
meaning of the word wonky but it sounds both good and correct).
And yes, the guide you gave the link to is a good guide.   I used Chapter
3, Creating Charts and Graphs when I first started to learn about Charts.
It did show me how to create a column chart very quickly.  The problem with
all the teaching documentation is that it is written by people with a lot
of knowledge so that you have to have more knowledge that the average
person has in order to understand what the teaching documentation is
saying.  I originally started the website Tutorials for OpenOffice.  At one
point there were more people coming to the Tutorials for OpenOffice website
than coming to the User Group at OpenOffice.  If anyone is interested I
would be glad to discuss this more.  There is a need to have teaching
material that supplements the official teaching documentation of LOo.

I have done just about nothing with the chart.  I will watch to see if the
lag time is a  problem.  I do have a problem.  The labels do go correctly
at the bottom of the charts when there are some negative numbers below the
zero line.  However if I make the chart wider, the negative part of the
column covers the title of the column

On Fri, Dec 23, 2011 at 11:11 AM, Tom Davies <tomdavies04@yahoo.co.uk
wrote:

Hi :)
There is a good guide here


http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide

I'm not really sure how to summarise as it sounds like you are doing the
right thing but something is obviously a bit wonky.  When you enter new
data to replace values in the data-range do you press enter and then give
it a little moment?  It doesn't take long but it's not exactly instant.
Perhaps a minute or less.

Apols and regards from
Tom :)


--- On Fri, 23/12/11, Walter Hildebrandt <wh9991@gmail.com> wrote:

From: Walter Hildebrandt <wh9991@gmail.com>
Subject: Re: [libreoffice-users] Chart in Calc
To: users@global.libreoffice.org
Date: Friday, 23 December, 2011, 14:16

Thank all of you for the help.  The chart is an embedded object that I
can
change and save.

On Fri, Dec 23, 2011 at 3:14 AM, Steve Edmonds
<steve.edmonds@ptglobal.com>wrote:

Hi.
I think if you click on the chart you should get handles on the outside
of
the chart.
You should be able to click on the lines (and other components) in the
chart and get handles.
You should be able to right click on these components with handles and
change properties.
steve


On 23/12/11 4:01 PM, Walter Hildebrandt wrote:

No, I do not have a chart that can be updated.  I open the spreadsheet
that
has the data wanted in the chart.  I then highlight (select) the data
that
is to be in the chart.  I click on the Chart icon.   A good column
chart
is
automatically created and the Chart Wizard appears.  I can use the
Chart
Wizard to modify what is in the chart such as adding a title.  I then
click
Finish which puts the chart in the spreadsheet as an image plus the
Chart
Wizard closes.  The image of the chart can not be modified.  What can
be
done so that there is a chant that can be updated?

On Thu, Dec 22, 2011 at 8:59 PM, Tom Davies<tomdavies04@yahoo.co.uk
**>
 wrote:

 Hi :)
Have you already got a chart that updates when you update the data?
It
should do unless you have done the classic of over-complicating
things
which i'm sure we all do from time-to-time.
Regards from
Tom :)


--- On Thu, 22/12/11, Walter Hildebrandt<wh9991@gmail.com>  wrote:

From: Walter Hildebrandt<wh9991@gmail.com>
Subject: Re: [libreoffice-users] Chart in Calc
To: users@global.libreoffice.org
Date: Thursday, 22 December, 2011, 20:34

Thank you Jay for the help that allowed me to figure out how to solve
my
problem.

On Thu, Dec 22, 2011 at 12:50 PM, Walter Hildebrandt<
wh9991@gmail.com

wrote:
I have inserted the chart onto a spreadsheet and it is now an image.
Am

I

correct that the only way to change the image is to start all over
again
and create a new chart?  If so, how can I save the new chart so that
it

is

always available to be changed?  I am using WindowsXP.


On Thu, Dec 22, 2011 at 11:02 AM, Jay Lozier<jslozier@gmail.com>
 wrote:

 On 12/22/2011 10:01 AM, Walter Hildebrandt wrote:

 I made a chart that had 2 problems.

1st problem:  There was a series of numbers under the columns
that I
believe were the names of each column.  The first column was 1,
the
second
column was 2, etc.   How do I change the number to the real name I
want
to
use?

 Either insert a new row A and enter the names or replace the
place
holders with the correct names in row A.


 2nd problem:  some of the columns were negative numbers and were
below
the
zero line.  This caused the column to be over the number (over the

name)

of
the column thereby hiding the number/name.  How do I correct this?

 Where you graphing the numbers?


--
Jay Lozier
jslozier@gmail.com


--
For unsubscribe instructions e-mail to:
users+help@global.libreoffice.

**

org<users%2Bhelp@global.**libreoffice.org<
users%252Bhelp@global.libreoffice.org>

Problems? http://www.libreoffice.org/****
get-help/mailing-lists/how-to-****<
http://www.libreoffice.org/**get-help/mailing-lists/how-to-**>
unsubscribe/<

http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/<
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>


Posting guidelines + more: http://wiki.**documentfoundati**
on.org/**<
http://documentfoundation.org/**>
Netiquette<http://wiki.**documentfoundation.org/**Netiquette<
http://wiki.documentfoundation.org/Netiquette>

List archive: http://listarchives.**libreoff**
ice.org/global/users/<
http://libreoffice.org/global/users/>
<

http://listarchives.**libreoffice.org/global/users/<
http://listarchives.libreoffice.org/global/users/>


All messages sent to this list will be publicly archived and cannot
be
deleted


 --
For unsubscribe instructions e-mail to:
users+help@global.libreoffice.
**
org <users%2Bhelp@global.libreoffice.org>
Problems?
http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/<
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette <http://wiki.documentfoundation.org/Netiquette>
List archive: http://listarchives.**libreoffice.org/global/users/<
http://listarchives.libreoffice.org/global/users/>
All messages sent to this list will be publicly archived and cannot
be
deleted


--
For unsubscribe instructions e-mail to:
users+help@global.libreoffice.
**
org <users%2Bhelp@global.libreoffice.org>
Problems?
http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/<
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette <http://wiki.documentfoundation.org/Netiquette>
List archive: http://listarchives.**libreoffice.org/global/users/<
http://listarchives.libreoffice.org/global/users/>
All messages sent to this list will be publicly archived and cannot
be
deleted



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.
**
org <users%2Bhelp@global.libreoffice.org>
Problems?
http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/<
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: http://wiki.**documentfoundation.org/**
Netiquette <http://wiki.documentfoundation.org/Netiquette>
List archive: http://listarchives.**libreoffice.org/global/users/<
http://listarchives.libreoffice.org/global/users/>
All messages sent to this list will be publicly archived and cannot be
deleted



--
For unsubscribe instructions e-mail to:
users+help@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted


--
For unsubscribe instructions e-mail to:
users+help@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted



-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.