I need help with creating a target line in an excel graph.
I have 4 parameters for which the targets are set in the beginning of the year. The parameter wise progress is updated month by month in the same sheet.
I want to create a dynamic graph using check boxes(for which i know the procedure).i.e when i choose parameter1 the monthly data for parameter1 will be visible.
I want a target line for Parameter that is selected by using a check box (the target remains constant for the whole year) against the monthly details.
In short - My X-axis will have months and Y-Axis will have numbers.
Please see the attached sample file with the data.
Thanks in Advance