Is it possible to hide or white color every 2 alternative labels in X-axis of a line chart

Follow

Dhrubajyoti Das

November 18, 2019 10:07

I have time series data for 5 years and my line chart has to show 60 data points in it (1 month as a point for 5 years). Since, there are many data points, I want to hide or change the color to white for every 2 alternative months. For ex, my chart would start from Jan,2019 and then next visible point would be April, 2019. You can say it will show the 1st month of each quarter. I tried to do it by taking a reference of some customization done in column chart but could not make it happen. Attaching the screenshot of my chart for reference.

Current:

Expected

1

• 

  Nathan Giusti November 18, 2019 20:42

  Hey Das,

  I think you could modify this to fit your case

  https://support.sisense.com/hc/en-us/community/posts/360033579294-Modifying-X-Axis-Labels

   

  Just keep a running a counter that increments for each label. Something like

  if (num %3 != 0)

  {

     set color to white

  }

  num++ 

  0

  Comment actions Permalink
• 

  Dhrubajyoti Das November 19, 2019 05:34 (Edited November 19, 2019 05:36)

  Hey Nathan,

  Thanks man for sharing this. I just realized I have taken reference of this post earlier too but dint click in my mind though. Thanks again.

  0

  Comment actions Permalink

Please sign in to leave a comment.