Forum Discussion

rajesh9147's avatar
rajesh9147
Regular Visitor
4 years ago

Custom line chart with background shading differentiating last year vs this year

Hi All, I have a requirement to compare last year data with current year data with a line chart and show the differentiation using background color shading. For ex, all the months in the last year 2...
Need Help
Tips and Tricks
rajesh9147's avatar
rajesh9147
Regular Visitor
4 years ago

Hello,

 

Thanks for your reply. I have tried the X-Axis Constant line and I got the background shade for the last year. I am looking for 2 lines with the current year and last year but I am missing all month's information on X-Axis. I have attached the latest screenshots. 

 

When I apply Type Continuous, I am able to see the background and missing Feb 2021 on X-Axis.

When I apply Type  Categorical, I am able to see All month's information but not the background.

 

Please let me know if I missing anything here.

 

Thanks,

Rajesh

  • KerKol's avatar
    KerKol
    Power Participant
    4 years ago

    Howdy, I'm please it worked 🙂

     

    That is expected behaviour for continuous axes, as they are continuous, there is no need to plot all values, especially if it is a measure that can be split into fractions. 

    Data: Continuous vs. Categorical (eagereyes.org)

     

     

    You should be able to add a second constant line on a continuous axis:

    and then add shade after