Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Is it possible to create a chart, graph in notes R6

I would like to ask is it possible to create a chart e.g. bar chart or pie chart in notes R6 database and display in notes r6 database view?

Please advise.
Thanks
0
kopibean
Asked:
kopibean
  • 3
  • 2
  • 2
1 Solution
 
Bozzie4Commented:
Not in standard Notes (you can create a bar chart, using some tricks)

You could use an applet to do this, or create an Excel sheet and embed that in a document ...
0
 
kopibeanAuthor Commented:
hi tom,

you mention i can create a bar chart using some tricks?
what are the tricks?
Pls advise.
Thank you.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Sjef BosmanGroupware ConsultantCommented:
You can also embed a Java-applet that does the drawing/charting for you. Works like a charm.
0
 
kopibeanAuthor Commented:
In one of my view, I have 2 columns.
1 column is Category which consists of Daily, Others, Trouble, Project, Misc, Upgrade.
2nd column is a total of how many cases for Daily, Others, Trouble, Project, Misc, Upgrade.

I would like to show this data in a bar chart whereby the x-axis is the category and y-axis is the no. of cases.

Thus, how am i going to implement?
Pls advise?
0
 
kopibeanAuthor Commented:
Java-applet? Where do I get this applet from?
Please advise.
Thanks!
0
 
Sjef BosmanGroupware ConsultantCommented:
In any case, you have to implement it using a form with a lot of code in the QueryOpen or PostOpen event. That code will get the data of the view, process it and place it in the graph. Ask Tom how to do this in Excel (I dunno :-$). The Java-applet you'd have to construct yourself, unfortunately.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now