OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to hide data in a graph?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Vesala
Newbie
Newbie


Joined: 11 Dec 2008
Posts: 2

PostPosted: Thu Dec 11, 2008 12:28 am    Post subject: How to hide data in a graph? Reply with quote

Hi,

My problem is that I can't hide data in a graph (x,y -diagram).

I have data in many columns and that data is represented in a graph. I have made macros that hide a specific column. The problem is that when I hide a column, the data is not hidden in the graph. Why isn't it and how can I do this?

I have search all the options and forum posts but I can't understand why the data is not hidden.

Thanks
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Thu Dec 11, 2008 11:18 am    Post subject: Reply with quote

The chart is simply displaying the numbers in the relevant cells, whether or not they are visible or hidden cells.

I suggest (provided the amount of data isn't huge) that you have "helper" columns that use an IF( ) function that looks at a cell that your Macro sets, something like:

=IF($E$1="Show";A1;0)

where your original data is in A1 and so on, and the chart refers to the cells with the IF( ) functions rather than the original data.

Sorry if this is unclear...
Back to top
View user's profile Send private message
Vesala
Newbie
Newbie


Joined: 11 Dec 2008
Posts: 2

PostPosted: Thu Dec 11, 2008 11:24 am    Post subject: Reply with quote

No, on the contrary, it's quite clear.

Thanks for the idea! I will try that.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group