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

Yes, that's where I started out - but I wanted the "histogram" or "top-hat"
way of connecting the datapoints, not "point-to-point".

"Jon Peltier" wrote:

You could use an area chart:

http://pubs.logicalexpressions.com/P...cle.asp?ID=508

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Curious27" wrote in message
...
Ah, I see - I needed to change the the chart type to "stacked column"
first
to get the "gap width" on the "options" tab. Ok - so now, is there a way
to
eliminate the lines that outline each column so each (stacked) series
appears
to be a contiguous area?
C.

"HEK" wrote:

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?