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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bozzie4IT ArchitectCommented:
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 ...
kopibeanAuthor Commented:
hi tom,

you mention i can create a bar chart using some tricks?
what are the tricks?
Pls advise.
Thank you.
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Sjef BosmanGroupware ConsultantCommented:
You can also embed a Java-applet that does the drawing/charting for you. Works like a charm.
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?
kopibeanAuthor Commented:
Java-applet? Where do I get this applet from?
Please advise.
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.

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.