If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 set x-y crossing on graph automatically
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## set x-y crossing on graph automatically

#1
October 26th 06, 02:24 PM posted to microsoft.public.excel.charting
 widman external usenet poster Posts: 103
set x-y crossing on graph automatically

Maybe this is a better place to have posted the question.

I have a graph set up where an input starts the range you want to look at. I
always want the "Y" to start at 0, and the scale nicely goes as high as
necesary for the numbers in the table (viscosity). If I want to look at the
100 degree temperature range starting at 0, the x axis works fine. but if I
choose to look at 50 and above, the "x" axis still starts with 0, leaving a
blank graph between 0 and 50 and still stopping at 100.

How can I set it so the x axis scale starts at the value selected?
#2
October 26th 06, 09:17 PM posted to microsoft.public.excel.charting
 Jon Peltier external usenet poster Posts: 6,582
set x-y crossing on graph automatically

Unfortunately Excel's algorithm for axis minimum nearly always gives you
zero as one endpoint. Only if the minimum and maximum differ by less than
about 1/6 of the full scale will Excel move away from zero. There's no
setting to undo this.

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

"widman" > wrote in message
...
> Maybe this is a better place to have posted the question.
>
> I have a graph set up where an input starts the range you want to look at.
> I
> always want the "Y" to start at 0, and the scale nicely goes as high as
> necesary for the numbers in the table (viscosity). If I want to look at
> the
> 100 degree temperature range starting at 0, the x axis works fine. but if
> I
> choose to look at 50 and above, the "x" axis still starts with 0, leaving
> a
> blank graph between 0 and 50 and still stopping at 100.
>
> How can I set it so the x axis scale starts at the value selected?

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post extend graph axis automatically in excel Alv_C Charts and Charting in Excel 1 October 13th 06 03:16 AM Bar graph and line graph overlayed MikeR-Oz Charts and Charting in Excel 4 February 6th 06 07:01 AM Hyperlinkage of one graph with another graph or Drill down graph Sanjay Kumar Singh Charts and Charting in Excel 1 January 3rd 06 12:22 PM Scatter Graph - Data Label Problems TBD Charts and Charting in Excel 2 January 16th 05 05:08 PM Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 01:09 PM

All times are GMT +1. The time now is 12:55 AM.