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


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

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.