• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 42
  • Last Modified:

Excel custom form with graph


With the help of expert Bill Prew, I developed a custom form that includes data driven by values in one of the worksheets.  Here's what the XLS does:

1. Upon opening this spreadsheet, a custom form is automatically populated based on value in cells A2:B4.  
2. The same form can be opened when clicking on the "Open Custom Form".  
3. Both processes (1. and 2.) work as envisioned.

Spreadsheet Modification:
- I now have added some additional sample data in cells A9:A11.
- The same data is represented in the graph as well.

What I need some help with:
- If doable, I would like to include/replicate the histogram (graph) into the custom form.
- My question:  If possible, how do I modify both the form and VBA to show the histogram in the custom form?
  • 2
1 Solution
Bill PrewCommented:
I think the only way you can do this currently is with an image of the graph, not the graph itself.  Examples can be found such as in these links:

ExpExchHelpAuthor Commented:
Thank you, Bill... I appreciate the pointers.
Bill PrewCommented:
Welcome, good luck, hope it works out well.

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.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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