scatter graph x-axis

Pugs107

New Member
Joined
Nov 18, 2005
Messages
19
I have a scatter graph that uses time values taken from a row for the x-axis. When the range of times is from 0:00 to 07:00, the graph looks great. If the times change to something like 12:00 to 19:00, the zero point on the x-axis stays 0:00 and the data gets compressed at the end. Is there a way to set the x-axis to be the actual times in the row?
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
Select the x-axis and right click to see the "Format axis" option and select it...

go to the "Scale" tab and click the "automatic" tick boxes...should do it I think.
 

Pugs107

New Member
Joined
Nov 18, 2005
Messages
19
Gave it a shot. Same results though. What happens is if the range is 0:00 through 07:00, the axis is 0:00 through 07:00. If the range is 12:00 through 19:00, the axis is 0:00 through 19:00. :confused:
 

Pugs107

New Member
Joined
Nov 18, 2005
Messages
19
I guess what I am asking is if I can format the x-axis to show only the pertinent times based on a selected range of cell and not all of the times from 0:00
 

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446

ADVERTISEMENT

Is your x axis and the data points plotted in the same area?

It sounds as if your x axis is constant although your data series is not.
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
Option 1: Set the axis by hand. Double-click the x-axis and in the resulting dialog box select the Scale tab. Specify the min. value as 12:00 (XL will translate it to a number) and the max as 19:00.

Alternatively, use a readymade solution like
AutoChart Manager
http://www.tushar-mehta.com/excel/software/autochart/index.html

Pugs107 said:
Gave it a shot. Same results though. What happens is if the range is 0:00 through 07:00, the axis is 0:00 through 07:00. If the range is 12:00 through 19:00, the axis is 0:00 through 19:00. :confused:
 

Pugs107

New Member
Joined
Nov 18, 2005
Messages
19

ADVERTISEMENT

Thank you tusharm. :) The add-in does exactly what I need. Will this be embedded in the worksheet, or would I need to install the add-in on any other computer that I may use?
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
Like any add-in it must be installed on each machine. Of course, the add-in is required only on those machines where the axis values actually change.
.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,911
Messages
5,575,001
Members
412,633
Latest member
simon_elvin
Top