View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
HEK
 
Posts: n/a
Default modifying the area plot to a "top-hat" instead of a "saw-tooth"

You can remove the space between the bars simply by making the gap zero.
Change to column chart, right click the series, Format Data Series / Options
/ Gap width 0. You may have to fiddle a bit with the number of series to
get the right desired effect.
HTH,
Henk

"Curious27" wrote:

I would like to modify the "stacked area" plot type so that the lines
connecting the data points do so in a "top-hat" or histogram style instead of
a "saw-tooth" or point-to-point connection. The bar plots aren't quite right
as the "bars" stand alone and have the vertical separators - instead of
forming a contiguous area under the data points. Is this possible?