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


    Sponsored Links


  • 1. Graphs from Excel into Adobe Illustrator
    When I copy a a 3-d pie chart from Excel into Illustrator it has jagged edges. How can I fix this? I used to copy as picture in the previous version of Excel and this worked fine, I am now using the latest version of Excel.
  • 2. Horizontally Banded Chart Background. - on Stock charts
    I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock type chart with 3 data points. I want to use a Horizontally Banded Background to indicate the desired range. I have read and tested Jon P's excellent article on Horizontailly Banded Chart Background, and tested it successfull on a line chart. However when I test it on the 3 var Stock chart it does not work. Can anyone give me a suggestion for a way to do what I want with either my stock type of chart or an alternative way to show what I want to indicate. Thanks from American Samoa JDB
  • 3. Comment balloon on a chart
    I have a chart that I want to put a "Comment Balloon" on. Is there a way to do this?
  • 4. Don't plot non-numeric cells
    Tools - Options - Chart - Plot empty cells as: Not plotted (leave gaps) works only when the cell is actually empty. The cell is empty when raw data is missing, but the raw data has to be subtracted from a constant value. I'm using =IF(ISNUMBER(B4), B$1-B4,NA()) which returns #N/A when B4 is blank. The cell is not empty and consequently is plotted as an interpolated value between B3 and B5. I've tried copying and pasting values only and using "" instead of NA() to no avail. Short of clearing the contents manually (5% missing data points scattered throughout 25,000 values) is there another way to leave gaps in the line chart?
  • 5. How can I save an excel 2007 chart in a vector graphics format?
    I need to be able to take charts from excel (preserving the vector format) and save them as EPS files. I tried copying a chart and pasting it in Adobe Illustrator, but the legend seems to get broken up and repositioning all the parts is a major pain. Is there a better way? thanks, Kit Neel engineering graduate student XXXX@XXXXX.COM

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 40 guest