#1   Report Post  
Posted to microsoft.public.excel.charting
JKC
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
chart size zdenek Charts and Charting in Excel 0 February 9th 06 09:58 AM
A Chart that Updates Automatically as Data Size Changes? Notclevr Charts and Charting in Excel 4 January 18th 06 04:19 PM
Print Excel charts in Word 2003 with fixed size Phil Charts and Charting in Excel 1 November 3rd 05 04:24 AM
Chart scale & paper size F3 New Users to Excel 0 May 27th 05 10:01 PM
export chart - size problem Art Parra Charts and Charting in Excel 1 December 7th 04 01:58 AM


All times are GMT +1. The time now is 09:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"