I am trying to create a chart that highlights a specific part on x axis. like in the image below. I have a column that indicates hour of the day. How to highlight hours between 8 am to 4 pm in an area or line chart? I tried reference lines - it did not let me use reference line on x axis.
Hi @priyanka2 ,
a way can be using Highcharts. If you have a look at this demo on our DemoCentral there is the Hands On lab where you obtain something like this at the end!
Let me know if this helps!
Andrea
Otherwise, a workaround can be having a calculated field which is like 1 when in the desired period, 0 eslewhere.
Then you can create a Area Chart and put the calculated field on the Right Y Axis.
An example: I want to highlight December.
MonthHighlight = ifelse(extract('MM', {Order Date}) = 12, 1, 0)
I put this value on the right axis:
And I obtain something like this:
Andrea
Hi @priyanka2
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @priyanka2
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!