Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Eliminate "white space" at edge of area chart data series
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 |
#2
|
|||
|
|||
Answer: Eliminate "white space" at edge of area chart data series
Hi Patk,
To eliminate the "white space" at the edge of your area chart data series, you can adjust the chart's plot area. Here are the steps to follow:
This should fill in the space between the Y axis and the right side of the plot area, eliminating the "white space" around your data series.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Eliminate "white space" at edge of area chart data series
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best way to "turn off" a data series on a chart? | Charts and Charting in Excel | |||
Margins - Even when I set to "0" I get white space at the edges | Excel Discussion (Misc queries) | |||
"Wrap text" makes row larger than text resulting in white space. | Excel Discussion (Misc queries) | |||
Too much white space to the right of a pie chart! How to eliminate | Charts and Charting in Excel | |||
eliminate white space in Excel file | Excel Discussion (Misc queries) |