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

Now I understand you.

Im afraid there is not such a solution you are looking for. Charts in general are based on a defined data range for the x-axis where all data on this range are includeded. But you want to make a data selection using a chart. You real task, the seclection of data (your x-axis data) is one step before making a chart.

I am afraid you have to do this manually or using a selecting criteria which allows you to pick up every 5th set of data and create a new x-axis with the relevant data on for the y-axis.

As you have only a data set of 35 and need to select only 7 data sets, I would simply do this manually. It's a 5 minute job.

On 2012-09-13 18:14, a a wrote:
ok now to the problrm in detail, In the original file that i want to
change, i have numbers 1-35 on the x-axel, which all shows in the diagram,
What i now want is to show only every 5 numbers (0.5.10 etc) so its easier
to read the chart. in pic Y-axel, i can change max/minimum range ,
intervalls between numbers etc. But when i try the same in x-axel i dont
get the alternatives to change them, as shows in the pic x-axel, the
options arent just there. btw i didnt mean that it as malfuncioanal
program, since its greatly done, but sometimes there are issuses needed to

2012/9/13 rost52 <>

I am not sure if i understand your problem correct but try to give you and
answer based on my understanding.

I you want to change the range for the x-axis you need (also in MS Excel)
to change the range and you cannot do this in the window (X-axis) you
opened, You must expand you x-axis data range beyond cell A10 to cover the
entire range you want to see in the chart.

Right click on the chart
select data range
select data series
select categories and expand the range here. You can keep the new cells
empty or continue from 10 to where you want to go.

LO Calc works correct. The mathematical logic in LO is correct.

If  my answer does not help you, could you please explain why you want to
do what?


On 2012-09-13 17:28, a a wrote:

I am now sending 2 pics, first shows how i want it, Where i can change the
values, (Y-axel) Second file is the malfuncional one? (X-axel) When i do
same thing on another computer i get Y-axel choices in grey, when i try
x-axel ,which doesnt allowe me to change the values. On this comp i get
what you see on X-axel pic. Problem remains in other words.

2012/9/13 rost52 <>

  Yes do so. All addtional information can help.

On 2012-09-13 15:45, a a wrote:

  Ty for all help, but i want to make a bar diagram X/Y wise. Should i
screenpic of the grey area and the diagram? Sometimes a pic can tell
then text.

2012/9/12 MiguelAngel <>

   El 12/09/12 16:26, Andreas Säger escribió:

    Am 12.09.2012 15:35, a a wrote:

When i am creating a diagram i can change the numeric values of the
but when i try the same procedure for the x-axel, the template with
stay grey and imposible to change. How can i do to make this grey
black again so i can change the numeric values?

/Magnus östlund

   Change the chart type to x/y-scatter chart.

Ignore Tom Davies. He is the most verbose ignorant on this list.

   Hi Andreas,

please forgive us, I believe, we all learn from you, and we are
for that, but IMHO we do not need to be encouraged with these

Miguel Ángel.

For unsubscribe instructions e-mail to: users+help@global.libreoffice.
org <users%2Bhelp@global.**libreof** <><
Posting guidelines + more: http://wiki.****documentfoundati****
<ht**tp://** <**>
List archive: http://listarchives.****libreoff****
users/ <><**
global/users/ <>>
All messages sent to this list will be publicly archived and cannot be

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

For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
org <>
Posting guidelines + more: http://wiki.****
Netiquette <>
List archive: 
All messages sent to this list will be publicly archived and cannot be

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.