Hi everyone,
Hopefully someone can help me out with this. I have a project plan which is made up from a stacked bar chart. I would like to have a table where the user can enter project names and the accompanying start/end data. Whenever there is a row which is blank, I would like the bar chart to dynamically remove this so that it only ever shows data in the table. Can this be done?
Many, many thanks in advance!
Last edited by sav1979; 03-21-2016 at 01:06 PM. Reason: Solved
Hello
Take a look at the attached file. It uses a dummy data set and helper column on the 'Week Calculations' tab. There a 3 dynamic named ranges feeding the chart on the 'Project Calendar' tab. When you enter data there the chart should update to show the Project data.
Hope this helps.
DBY
Thank you so so much DBY. You're an absolute legend. That is really, really helpful.
Glad to have helped. Thank you for the Rep mark.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks