needhelp858
New Member
- Joined
- Aug 4, 2017
- Messages
- 1
Howdy !
My first post on Mr. Excel, so let me know in the comments if I left anything out.
I have attached a simplified version of my project which illustrates my problem of creating a chart, when the data dynamically changes quantity, the graph gets thrown off.
You can see that if you change the subject in the drop down menu, the graph gets messed up because each subject has a different duration and therefor a differently structured x axis. My simple goal is just to have the graph display dose over time in a normal looking manner when you change from subject to subject.
let me know if anyone can help with this!
My first post on Mr. Excel, so let me know in the comments if I left anything out.
I have attached a simplified version of my project which illustrates my problem of creating a chart, when the data dynamically changes quantity, the graph gets thrown off.
You can see that if you change the subject in the drop down menu, the graph gets messed up because each subject has a different duration and therefor a differently structured x axis. My simple goal is just to have the graph display dose over time in a normal looking manner when you change from subject to subject.
let me know if anyone can help with this!
