View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
PatK PatK is offline
external usenet poster
 
Posts: 96
Default Eliminate "white space" at edge of area chart data series

That was almost "painfully" simply. Thanks Andy!

Patk

"Andy Pope" wrote:

Hi,

xl2003. Double click X axis and on Scale tab uncheck Value (Y) axis crosses
between categories.

xl2007. Right click X axis Format Axis. Axis Options Position Axis:
On tick marks.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"PatK" wrote in message
...
I have a stacked area chart, and while the data is plotted just fine, to
the
left and right of the plotted data series, is "white space" (looks like my
area chart has cliff on either side).

Any way to make the area chart fill in the space between the Y axis, and
the
right side of the plot area?

Thanks!

Patk