Reference Line?
Hi!
I wonder how to set a reference line of salary range that people can move it to split the graph into two groups by showing different colors:
Before:
After:
Thank ya!!!
-
1. Re: Reference Line
1. Create a parameter
2. use that parameter for referance line
3 create a boolean express and use it as color. In my case sum([Sales])<[Parameter 3]
Please see below screenshots and let me know, if any question
-
2. Re: Reference Line
Hi Arvindgarg!
Thanks for your answer!
I am still a little confused about how to set the parameter and I attached my file, could you please show me how~~?
Best,
Lu
-
3. Re: Reference Line
I dont see any line graph in this workbook. On which sheet you want to do that?
-
4. Re: Reference Line
Hello,
Please find my approach stored in the attached workbook.
You can also make it dynamic by creating a parameter that takes values between 0 and 1. Both the approaches you will find in the workbook.
Hope this helps.
~Tushar
-
5. Re: Reference Line
Hi！
The bar graph is what I have, do you think it is possible to make a reference line just like the line graph?
-
6. Re: Reference Line
Sorry your question is not clear to me. What values you want plot as a reference line? Could you show the output you want?
-
