Macro for Graph Pop up

[clramjit]

Hi all,

I will get right into it:

I have a workbook I am working on. It is being designed to collect data about person's medical checks on a monthly basis (eg. BP, Weight, Cholesterol etc..) Each of the Sheet will be identical in data collection with different person's names. Now what I want to do is have a toggle button to make a Graph Pop up/close, to capture data for specified months (Jan -Dec) or therein in any given spreadsheet for each of the columns with data. Can this be done? Can anyone help with the Macro for this. I can attach the spreadsheet if requested.

Thanks a lot in advance

CLR.

 

[Hui]

CLR

Firstly, Welcome to the Chandoo.org Forums

What you effectively need is a dashboard

Luckily Chandoo.org has lots of help on making dashboards, simply use the help at the main page

I'd also suggest setting up some dummy data so you can ask questions of people here
2 patients will be plenty