![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
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?
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?
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?
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.
Thank you Jay for the help that allowed me to figure out how to solve my
problem.
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
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?
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
Thank all of you for the help. The chart is an embedded object that I can
change and save.
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
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
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
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.
about ur 2nd problem, does this help?
regards,
sorry forgot to attach the link- http://youtu.be/NcYwVHIN2lE?hd=1
regards,
about ur 2nd problem, does this help?
regards,Dr soumalya ray <http://drsoumalya.blogspot.com> <drsoumalya@gmail.com>
MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp <http://twitter.com/docbkp>
I am using WindowsXP and can do what you did in cells A1, A2, A3, B1, B2,
and B3. The six cells are highlighted (selected). The Chart Icon is
clicked. The Chart appears along with the Wizard. How do I get rid of the
Wizard without deleting the Chart at the same time? By deleting the
Wizard it seems to allow you to go on further. If I keep the wizard I can
not do what you do in the video.
Also, The title of each column appears just below the zero line. When I
have a negative number in either cell(s) B1, B2, or B3, then the dark blue
column goes below the zero line and covers (hides) the title.
As for the title of the complete chart, I can add that at the top of the
chart by keeping the Wizard and using the Wizard to add the chart title on
a line that is above the highest columns so there is no hiding any part of
that title.
just click the "finish" button of the wizard.it'll disappear then.
that's why i move the title of the column to the end.otherwise,you could
just change the colour of the font of the title of the column from
"automatic" to something suitable to make it legible.
regards,
*I am using WindowsXP and can do what you did in cells A1, A2, A3, B1, B2,
and B3. The six cells are highlighted (selected). The Chart Icon is
clicked. The Chart appears along with the Wizard. How do I get rid of the
Wizard without deleting the Chart at the same time? By deleting the
Wizard it seems to allow you to go on further. If I keep the wizard I can
not do what you do in the video.*Also, The title of each column appears just below the zero line. When I
have a negative number in either cell(s) B1, B2, or B3, then the dark blue
column goes below the zero line and covers (hides) the title.As for the title of the complete chart, I can add that at the top of the
chart by keeping the Wizard and using the Wizard to add the chart title on
a line that is above the highest columns so there is no hiding any part of
that title.--
Dr soumalya ray <http://drsoumalya.blogspot.com> <drsoumalya@gmail.com>
MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp <http://twitter.com/docbkp>
It seems you know what is going on with charts. The official documentation
has a lot left out. You send a link that had the video of what to do. I
did not save that link and it seems to be deleted from the Emails. Please
send me that video link again. Thank you.
By the way I am the person who originally started the website
TutorialsforOpenOffice.org. We learned a lot on how to write tutorials in
a way that works for many users of OOo or TOo. Do you know anyone who is
interested in discussing this?
Hi
You can always view the emails through Nabble. Navigate to the right thread
or click the click in this post. Errr, actually here is the link to the
video again
http://youtu.be/NcYwVHIN2lE?hd=1
The documentation team might be interested in joining in with the video work
Regards from
Tom
Hi: Thank you for the link. Yes, it would be an advantage if the
documentation team works with the video people. I am the original creator
of the website Tutorial for OpenOffice.org. I gave the website away and
do not know who has control of the website now. Anyhow I think it would be
a huge advantage if the documentation team worked with the Tutorials for
OpenOffice.org website. At a time back when I was involved we were getting
more questions than the User Group at OOo. When a question was ask that
the tutorials website could not ask, it referred the questioner to the OOo
User Group. Very ofter we got feedback that they had tried the OOo User
Group and thought it was no good because it did not help them so they came
to us for help. The tutorials website found out our success was because
how we wrote the tutorials. The tutorials were written as simple steps.
At this time, even though I am fairly well knowledgeable with OOo and LOo,
I can not understand what the video is showing and I can not understand
what much of the Calc Guide, Chapter 3, Creating Charts and Graphs is
saying. It would be helpful if instructions was in a simple step by step
format. For example 1. open a new spreadsheet 2. In cell A1 type
June 3. In cell B1 type the number 5 4. in cell A2 write etc
Highlight (select) cells A1, A2, A3, B1, B2, B3 Click on
the chart icon (have a picture of the chart icon There is a better way
to word what I just gave as an example. The bottom line is that in some
way (maybe just a link to begin with) the documentation group, the video
group, the tutorials website should be "working together" (should be"be
coordinated").
Now that the corporation's self-interest does not seem to be a factor, and
there is two separate forks, it is time for the two forks to get back
together as one group so there is no duplication and waste of physical
energy and capital resources.. I see little or no value in the idea that
the two forks create competition that is good. There is enough competition
within one group to stimulate creativity. Now that a lot of things have
happened we might have learned how to handle differences of opinions within
one group. Differences of opinions is what caused there to be the
tutorials website, the User Group, the video approach, and the document
team. You might have already demonstrated how to work together with
different opinions by using links to "integrate" the different opinions.
Hi
In any other industry competition would be seen as a good thing. Which flavour of ice-cream do you prefer? Should everyone wear identical ties bought from the same company? If there was less variety in styles of music then a lot of effort could go into making that one style really great? Should people have a choice of who to vote for? What colour car, what manufacturer? And so on. Somehow in desktop computing people think there should be a lack of choice and think that everyone should go with the dominant product.
Regards from
Tom