About This Code
Brief Description:
Generates a graph in MS Excel from a categorized view. (Using the second column as totals)
Contributor:
Jeff Blackadar
Category:
Application, Lotusscript
Last Modified:
26 May 2006
OpenNTF Disclaimer
All of the program code and information presented in the OpenNTF.org Code Bin are provided "as-is", and should be used at your own risk. OpenNTF.org make no express or implied warranty about anything in the Code Bin, and OpenNTF.org will not be responsible or liable for any damage caused by the use or misuse of anything from this site. OpenNTF.org makes no guarantees about anything. Please thoroughly test all of the knowledge and code you find here before you attempt to use them in your production environment.
Code / Description
The database has a script library that has a function that will generate a graph in Excel from a categorized view if the second column has totals. The idea is you can insert the script library and an action button and generate graphs from categorized views quickly.
A sample view and data are included in the .nsf
Usage / Example
Your client has categorized views and they want to graph the resulting totals (useful for graphing survey data for example)
Code Attachments
Comments
Posted by Ken OShea on 09/10/2010 09:35:11 AM"Subscript out of range"
I get a "subscript out of range" error while trying to execute this code in both the sample and with a real db. I am running the Notes 8.5 client.