Hi guys, looking to find a solution to a dynamic chart. I'm looking to chart Forecast, Cumulative Forecast, Actuals and Cumulative Actuals on a 12 month axis. The kicker is that I have several sub segments from a job to chart. So for job 61383, I have to chart 61383-DS-001-020, 61383-DS-001-021, etc. Instead of charting 30 of these sub segments, I'm looking for a way to drop the data somewhere and use a drop down menu to show only one sub segment in the chart at a time.
This is the data that I have to combine somehow, Forecast for 12 months, Actuals for 12 months, and Cumulative for each for 12 months.
The current chart looks something like this, charted with the single input info on the left. But again, I need to make this for 30+ sub segments and maintain the chart parameters.
Any help is much appreciated.
This is the data that I have to combine somehow, Forecast for 12 months, Actuals for 12 months, and Cumulative for each for 12 months.
The current chart looks something like this, charted with the single input info on the left. But again, I need to make this for 30+ sub segments and maintain the chart parameters.
Any help is much appreciated.