ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart size (https://www.excelbanter.com/charts-charting-excel/71437-chart-size.html)

JKC

Chart size
 

I have a simple line graph on a worksheet. How can I eliminate large gap
between end of graph and edge of chart. I looked in all properties etc.
but I can't figure out how to make end of graph line go the edge of the
graph area. Thanks


--
JKC
------------------------------------------------------------------------
JKC's Profile: http://www.excelforum.com/member.php...o&userid=31166
View this thread: http://www.excelforum.com/showthread...hreadid=511942


Andy Pope

Chart size
 
Hi,

If you want the line to go from edge to edge of the plot area then
double click the x axis and on the scale tab uncheck 'Y (value) axis
crosses between categories'

Cheers
Andy

JKC wrote:
I have a simple line graph on a worksheet. How can I eliminate large gap
between end of graph and edge of chart. I looked in all properties etc.
but I can't figure out how to make end of graph line go the edge of the
graph area. Thanks



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 04:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com