Hi,
I have a graph on the capacity of a work site. The graph show data that is the available man hours and what is required. I would like to have a tab above the chart that will take into account absenteeism (there are a number of work sites and therefore will differ). how can I have a field that can be entered that will adjust the graph according to the entry?
Thanks
Do you have a sample file that you can upload?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hello,
take a look at Jon Peltier's page about dynamic charts: http://peltiertech.com/Excel/Charts/Dynamics.html
If you get stuck, post a sample file and explain your requirements.
cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks