
New Member

July 9, 2020

Hello,
I am following the directions on this tutorial for Option 1: https://www.myonlinetraininghu.....s#comments
The example data is representing a gap in products sales, so Sept and Oct are showing a good number so I would like those values to be green to highlight them. However, I cannot get it to work as described in the tutorial.
Thank you so much for your help!


July 16, 2010

Hi Laurel,
Welcome to our forum!
Thanks for sharing your file. You need to do two things:
1. the values in the green series in column D must include the values from Red for August and November. This is so that the green series line connects to the red series line.
2. right-click the chart > Select Data > Hidden and Empty Cellls > check the box for 'Show #N/A as an empty cell'.
Mynda
1 Guest(s)
