Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart displaying sales by product line vs a set standard. Currently both series are displayed as Bars side-by-side. I would preffer to display the standard as a horizontal line on top of the bar. I can achieve something close by switching the chart type to combo and displaying standard with a symbol only, but my choices are limited to "point-style" selections. Alternatively I can change the color of the standard series to transparent and increase the bar border width, but I cannot get 100% overlap of the two bars. Any thoughts on how I might achieve my disired display style?
Scott,
Try "display option" (Expressions tab) for line chart as "Plateau (center)", and no distance between bars. It is close to what you need, except the vertical lines of the line chart.
Regards,
Michael
Scott,
Try "display option" (Expressions tab) for line chart as "Plateau (center)", and no distance between bars. It is close to what you need, except the vertical lines of the line chart.
Regards,
Michael