How to get the series data points to align with corresponding date grid lines on chart axis?

206
0
12-08-2020 12:49 PM
JulietK
Occasional Contributor II

Hi I'm having an issue where the lines representing the months on a chart axis shows the beginning of the month, but the data points on the series line are located at the end of the month. 

JulietK_0-1607459511473.pngThe left shows chart grid lines for months Jul 19, Sep 19 and Nov 19. 

123.jpgThe data point for value '90' is for the month of Nov (I checked, that the value '1' is for month of Jul etc), though the date shows as 1/11/19. Is there a way to align the data point to the relevant month's grid line, to make the chart clearer and less confusing? Since the data points don't match up locationwise with the chart axis grid for the months, its confusing for the dashboard viewers to see which data points represent which month. It would also be helpful to be able to customise the hover labels to only show '11/2019: 90'

 

The chart parsing pattern is set as below.

JulietK_2-1607460129628.png

Any other parsing pattern options result in this

JulietK_3-1607460232659.png

 

Any advice would be appreciated, thanks!

0 Kudos
0 Replies