I have a bar chart, with one 'OnChange Of' field and two 'Show Value' fields. I want one of the axes to display as a line. However, when I set it up, it displays with 'handles', which I don't want. I can't find any way to eliminate them. I've even tried setting it up as an area, using a trendline and setting the area itself to transparent. This works as long as I'm in the Preview mode, but when I go to Design and back to Preview, the area reverts back to black.
Anybody know a way around this?