I am trying to do a bar graph using data created by the row function.
I highlight the title of the column and the two rows below it assuming I will catch the next row when Jet expands. All I obtain is the first line and it shows highlighting of the last row after the expansion of the row command.
How do I get this to work? I have attached a copy of the file.
Thank you,
Will
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Will,
Maybe somebody else know how to do it better? But I don't think the graph that you asked is possible to do with NL(Rows) function. You need to have a fixed row & fixed column to be able to do that.
With NL(Rows), the best that you can do is to have a clustered bar just like what i show you in the attachment. This might not be what you are looking for, but maybe give you an idea how to develop your report further.
Andy
Please sign in to leave a comment.