2012 Archives by date, by thread · List index

# Re: [libreoffice-users] Re: calc

I indeed understood that you want to show the y-value of every fifth x-value. However, it seems you don't want to stick with the pattern but want to be more flexible.
```
```
In general a graph displayes the correlation between a series of x-values and their related y-values. The x-axis is in any spreedsheet is a continuum of cells. If your dataset has more x-values as you want to show in the chart, then a selection of data needs to be made in a way that you have at the end of continuum of cells for the x-values. Therefore a manual selection made or a smart formular or macro needs to be made to create this continuum of cells filled with x-values which you want to show in your chart.
```
Here is a last idea, which could possibly be of use.
```
Create the chart with the full set of data you have. Select the bars you want to show. Change the color of these bars to put emphasis on them.
```

On 2012-09-13 18:37, a a wrote:
```
```i think i get how you mean, if i understand you right using your method
will get me one bar on 0, one bar on 5, one bar on 10 etc. I want the bars
to be on varius places on the x.axel depending on the chart i am doing, but
i want only to see every fifth number on the x-axel line. For example say i
want one bar on position 3 on the x-axis but that number shouldnt be shown
on the axis,

2012/9/13 rost52 <bugquestcontri@online.de>

```
```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
improve.

2012/9/13 rost52 <bugquestcontri@online.de>

I am not sure if i understand your problem correct but try to give you
```
```and

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.

do what?

ROSt

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
the
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.
/Magnus

2012/9/13 rost52 <bugquestcontri@online.de>

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

```
```send
a
screenpic of the grey area and the diagram? Sometimes a pic can tell
more
then text.
/Magnus

2012/9/12 MiguelAngel <mariosv@miguelangel.mobi>

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

Am 12.09.2012 15:35, a a wrote:
```
```   Hey,

```
```When i am creating a diagram i can change the numeric values of the
```
```y-axel,
but when i try the same procedure for the x-axel, the template with
options
stay grey and imposible to change. How can i do to make this grey
area
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
```
```grateful
for that, but IMHO we do not need to be encouraged with these

Regards.
Miguel Ángel.

--
For unsubscribe instructions e-mail to:
users+help@global.libreoffice.
****
**
org <users%2Bhelp@global.****libreof**fice.org <
http://libreoffice.org><
users%252Bhelp@**global.**libreoffice.org<http://global.libreoffice.org>
<users%**25252Bhelp@global.libreoffice.**org<users%2525252Bhelp@global.libreoffice.org>
Problems? http://www.libreoffice.org/*****
***get-help/mailing-lists/how-<http://www.libreoffice.org/******get-help/mailing-lists/how->
**to-*<http://www.libreoffice.**org/****get-help/mailing-**
lists/how-to-*<http://www.libreoffice.org/****get-help/mailing-lists/how-to-*>
*** <http://www.libreoffice.org/******get-help/mailing-lists/how-**
to-****<http://www.libreoffice.org/****get-help/mailing-lists/how-to-****>
<http://www.**libreoffice.org/**get-help/**mailing-lists/how-to-**<http://www.libreoffice.org/**get-help/mailing-lists/how-to-**>
unsubscribe/<http://www.****libr**eoffice.org/get-help/**<**
http://libreoffice.org/get-**help/**<http://libreoffice.org/get-help/**>
mailing-lists/how-to-******unsubscribe/<http://www.**
libreoffice.org/get-help/****mailing-lists/how-to-****unsubscribe/<http://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/**
<ht**tp://documentfoundation.**org/**<http://documentfoundation.org/**><
http://documentfoundation.**org/**<http://documentfoundation.org/**>
**>
Netiquette <http://wiki.****documentfoundat**ion.org/****Netiquette<http://ion.org/**Netiquette>
<http://**documentfoundation.org/****Netiquette<http://documentfoundation.org/**Netiquette>
<http://**wiki.**documentfoundation.org/****Netiquette<http://wiki.documentfoundation.org/**Netiquette>
<http://wiki.**documentfoundation.org/**Netiquette<http://wiki.documentfoundation.org/Netiquette>
List archive: http://listarchives.******libreoff**ice.org/global/**
users/ <http://ice.org/global/users/>**<http://libreoffice.org/**
global/users/ <http://libreoffice.org/**global/users/<http://libreoffice.org/global/users/>
```
```
```
```<http://**listarchives.**libre**office.org/**global/**users/<http://libreoffice.org/**global/**users/>
<h**ttp://listarchives.**libreoffice.org/**global/**users/<http://listarchives.libreoffice.org/**global/users/>
<http://listarchives.**libreof**fice.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.**libreof**fice.org <http://libreoffice.org><
users%252Bhelp@**global.libreoffice.org<users%25252Bhelp@global.libreoffice.org>
Problems? http://www.libreoffice.org/******get-help/mailing-lists/how-
**to-*<http://www.libreoffice.org/****get-help/mailing-lists/how-to-*>
***
<http://www.libreoffice.org/****get-help/mailing-lists/how-to-****<http://www.libreoffice.org/**get-help/mailing-lists/how-to-**>
unsubscribe/<http://www.**libr**eoffice.org/get-help/**<http://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/**
<ht**tp://documentfoundation.org/** <http://documentfoundation.org/**>
**>
Netiquette
<http://wiki.**documentfoundat**ion.org/**Netiquette<http://documentfoundation.org/**Netiquette>
<http://**wiki.documentfoundation.org/**Netiquette<http://wiki.documentfoundation.org/Netiquette>
List archive: http://listarchives.****libreoff**ice.org/global/**
users/ <http://ice.org/global/users/><http://libreoffice.org/**
global/users/ <http://libreoffice.org/global/users/>>
<http://**listarchives.**libreoffice.org/**global/**users/<http://listarchives.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<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
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
```