| View previous topic :: View next topic |
| Author |
Message |
blink182
Newbie
Joined: 07 Jan 2007
Posts: 1
|
 Posted: Sun Jan 07, 2007 9:36 am Post subject: Graph |
 |
|
Hey,
I have 2 problems with graphs.
First I need a graph just when a value is available, if there is no value, the programm should not show a graph.
The second thing is, I want to choose just some parts for a graph for example A1,A2 and C1,C2 but without B1,B2. How do I have to write this?[/code] |
|
| Back to top |
|
 |
Warrick Nelson
OOo Advocate
Joined: 04 May 2004
Posts: 203
Location: Christchurch, New Zealand
|
| Posted: Mon Jan 08, 2007 1:56 am Post subject: |
|
|
Second part
Select the first part, then use Ctrl to add the other parts to graph and continue with the graph wizard as normal.
Alternatively, select and graph all, then click and modify data range.
For your example, range would be $Sheet1.$A$1:$A$2;$Sheet1.$C$1:$C$2 |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Tue Jan 09, 2007 7:59 am Post subject: Re: Graph |
|
|
[quote="blink182"]Hey,
I have 2 problems with graphs.
First I need a graph just when a value is available, if there is no value, the programm should not show a graph.
/quote]
How are you creating the graph? It sounds like this question might be better in the Macros and API forum.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
