Should allow: "Value (X) axis crosses at *-MINIMUM-* value



  • 1. Excel 2007 Line Chart with Markers
    I'm using a Line Chart With Markers tracking 4 data lines: Red with Circles Black with Squares Blue with Diamonds Yellow with Triangles The yellow with triangles is very light and doesn't show very well in my PP presentation. I would like to change the color of just that one line. How do I do that?
  • 2. Help with "clusters" of plotted data
    I've been looking everywhere and I cannot seem to find a solution to my problem. I have data in my spreadsheet that is 'test' data from a lab. The lab doesn't generate data over weekends/holidays, so I'll have a bunch of data points from M-F dates, but then there is a gap in days then the data starts flowing again. 10-2-2009 10-5-2009 10-6-2009 10-7-2009 10-8-2009 10-9-2009 10-12-2009 When I plot this data using the X-Y graph (my situation isn't conducive to using a line graph), I'll have clusters of 5 days worth of data...a 2 day gap on the x-axis for the weekend and then another cluster. I want to have the sequential data points connected by a line and not have a line across the data gaps. Is there a way to do this?
  • 3. Disappearing Data Label in chart
    I have Excel 2003 I have a clustered column chart that shows the date that a monthly report was turned in from each unit. I put data labels on each column that show the week number and the date, so the chart for October would show: "Wk1 10/6" or Wk1 10/22 but for one unit, the data label has disappeared. By clicking around I can find the box for the unit up at the top of the chart but if I pull it down to the position I want it in (and have also found the option for it and chose "center" ) when I click off of it it disappears again and is invisible at the top of the chart again! Any idea how I can fix this? I have done "chart options" / "data labals" and made sure everything is checked correctly, and clicked on the single column and clicked on "format" / "data labels" and made sure everything is checked, but nothing seems to work any suggestions would be greatly appreciated as this is very annoying. thanks, Meenie
  • 4. customise y axis on clustered bar chart
    How can i change the value of y axis on a clustered bar chart t?
  • 5. Excel Command
    Hi friends I want to know in excel as per followings 1. How change upper and lower case in Ms Excel. 2. How to add text with number and it calculated alos for example : A B C 1 4 pcs 2 pcs =sum(A1:B1)

Should allow: "Value (X) axis crosses at *-MINIMUM-* value

Postby Q2hhZGlsbGFj » Wed, 09 Aug 2006 03:02:54 GMT

I think that almost always I want the X axis values and label at the BOTTOM 
of the plot. 

There is an option for them to be at the top.  Why not the bottom??

MS could put in a button for max or min value. 

This post is a suggestion for Microsoft, and Microsoft responds to the 
suggestions with the most votes. To vote for this suggestion, click the "I 
Agree" button in the message pane. If you do not see the button, follow this 
link to open the suggestion in the Microsoft Web-based Newsreader and then 
click "I Agree" in the message pane.


Re: Should allow: "Value (X) axis crosses at *-MINIMUM-* value

Postby Jon Peltier » Wed, 09 Aug 2006 08:39:53 GMT

I've suggested this, but it lies in the "Don't hold your breath" category.

What you can do, if you always want the axis to lie at the bottom, is to set 
a ridiculously low value for "Crosses At", like -1E300 (or 1E-300 for a log 
scale). If the axis minimum is greater than this number, Excel uses the 
minimum. Since you've selected such a low number, the minimum should always 
be above your number.

- Jon
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions

Similar Threads:

1.Need PivotChart x axis to cross Y axis at minimum Y axis value

I see an option to have x cross y at max y, but how can I say min y?

2.Hiding Values Below Z Axis Minimum Value on Axis Charts

I want to use an area chart to show values for data series above a certain 
minimum Z axis value. Unfortunately, I can't find a way to hide parts of 
series that have values below this minimum. The chart shows a continuation of 
the series as though the values were AT the minimum. I've also tried to 
manually clear cells in the table that have values less than the mimum but 
that hasn't worked. Any suggestions?

3.Value (Y) axis crosses between categories and Secondary Value (Y) Axis

Hi all -

I have 7 series on my chart
Series 1 is column chart - may be area chart eventually (2007 data)
Series 2 is column chart 2008 data
Series 3 is column chart 2007 avg
Series 4 is a column chart 2008 avg
Series 5 is a line chart (32,0 benchmark)
Series 6 is a line chart (points to column chart for 2007 avg, I then
add text to right to explain the column)
Series 7 is a line chart (points to column chart for 2008 avg, I then
add text to right to explain the column)

I would like the column charts for 2007 and 2008 data to be flush to
the origin (12 data points each year)
I would like the benchmark line chart of 32 to span the chart area
from left to right (16 data points)

>From what I've read, the way to accomplish this, is to clear the tick
mark from Value (Y) axis crosses between categories when formatting
the x axis.

However, when I do that, the data point for 2007 closest to the origin
appears cut-off on left side of column

I more or less posted this information on Ozgrid a few days ago
(Ozgrid is now down until Nov. 13 according to the site). Andy Pope
replied that if I move the line charts to the Secondary Value (Y)
Axis, that would resolve the problem.

I must be doing something wrong. I did assign the line chart to
Secondary Value (Y) Axis and then cleared the tick mark on the x axis:
Value (Y) axis crosses between categories. However whatever datapoint
is closest to the Primary Y Axis disappears entirely

What am I doing wrong here?
Send a confidential e-mail for a sample copy of the workbook
Best regards,

4.Changing value of chart axes based on the minimum value of the plotted series


I am trying to create a code to define the minimum value of the Y-axi
based on the minimum value of the plotted series.  Something wrong wit
the code.   Perhaps anyone give me an idea how to do this!!!
Thanks and more power!!!

With ActiveChart.Axes(xlValue)
dblMin = .MinimumScale
End With     
With ActiveChart.SeriesCollection(SeriesNo)
nminValue =  min(.Values = "=Table1!R1C1:R10C10")  
<------Perhaps somethig wrong with this line.
End with

If dblMin = 0 then 
dblMin = nminValue
With ActiveChart.Axes(xlValue)
.MinimumScale = dblMin
end with
end If


5.Using a cell reference as the axis value for Horizontal axis crosses

Is there any way of referencing a cell as the value in the "axis
value" area of the "Format Axis dialog box. I am currently entering a
number i.e. 2.5. I would like to be able to have this number change
when a user enterer a value in a cell?  Would it have to be VBA code
or is there another way?

6. Can't get the x-axis to cross at value 0 for both y-axes

7. X-axis to cross Y-axis at avrg Y-value

8. Minimum Value & Cell Cross Referencing

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 87 guest