Chart that will chart a row or row that a user selects

[mjfox52610]

I'm in need of modifing the Code in the File so it will chart a row or rows that a user selects or even better a message box that will ask for the row or rows the user wants chartedGraph in work.xlsm

[dilipandey]

Hi mjfox,

Cell A3 of sheet "template" is doing that. what ever row you want to chart, just enter the assoc# of that


Regards,
DILIPandey
<click on below * if this helps>

[Bhuvi]

I'm in need of modifing the Code in the File so it will chart a row or rows that a user selects or even better a message box that will ask for the row or rows the user wants chartedAttachment 243994

Hi Mjfox,

In the attached sheet I have added a validation in the cell A3 (template tab) from where you can select the associate nos. from a drop down list.
Also inserted is a macro which opens an input box for you to enter value when you select cell A3 in template tab.

You can use/keep whichever you wish to

Regards,
Bhuvanesh

Please click on the star* below if my solution helped.

[mjfox52610]

Thank You! Works Perfectly!

Hi Mjfox,

In the attached sheet I have added a validation in the cell A3 (template tab) from where you can select the associate nos. from a drop down list.
Also inserted is a macro which opens an input box for you to enter value when you select cell A3 in template tab.

You can use/keep whichever you wish to

Regards,
Bhuvanesh

Please click on the star* below if my solution helped.