I have been trying to show a background color to the label that I am using in my line chart. I know that this is possible in the Map chart, but is there any way to get the same in line chart as well.
Below is the screenshot of the sample label as required by me. I have used annotations to achieve that green box, however I need to achieve the same for all the labels without annotations since my database has large data set.
Attached is the sample workbook. Any suggestions would be of great help.
Thanks in advance.
Hi,
I've got one workaround using reference line, hope this will server your purpose
Change the marks of your label from text to details.
right click on your secondary axis and add reference line, set the values as per the screen shot
Now little formatting required, right click on any mark and select format
Now set the color of shading as per your requirement
You're done
workbook attached for your reference. Let us know if this works.
Mahfooj
