### Changing value of chart axes based on the minimum value of the plotted series

by **Billabong** » Sun, 17 Oct 2004 19:00:07 GMT

Hi,
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)
.Select
dblMin = .MinimumScale
End With
With ActiveChart.SeriesCollection(SeriesNo)
.Select
nminValue = min(.Values = "=Table1!R1C1:R10C10")
<------Perhaps somethig wrong with this line.
End with
If dblMin = 0 then
dblMin = nminValue
With ActiveChart.Axes(xlValue)
.select
.MinimumScale = dblMin
end with
end If
BR,
Bil

### Similar Threads:

1.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?

2.Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed

SITUATION: I've never used Exel for chart-creation. This question
probably makes that all too obvious.
Using Exel 2002's chart wizard, I was able to generate a time-series
chart which displayed my data. However, on the resulting chart, the Y
Axis displayed the years generically (1-30). I wanted this axis to
display the years specific to the dates involved (e.g. 1920-1947).
I right-clicked on the Y Axis and choose <Format Axis>, followed by
the Scale Tab. There I set "Minimum:" to the starting data of my time
series, "Maximum:" to the ending date. All other values were kept the
same. I then clicked OK. The chart was now formated just the way I
wanted it.
However...
PROBLEM: The data plot line on the newly-formated chart is invisible
-- it "disappeared".
QUESTION: How do I get the chart to display **both** the time-series
data on the Y-Axis by date and the resulting data plot?
COMPLAINT: This **really** shouldn't be this
difficult!!!!!!!!!!!!!!!!!!!!!
Thanks,
2privatus

3.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?

4.Formatting a data series to run value axis to value axis

I am working on a combination chart where two data series are stacked
and the third data series is shown as a line chart. What we want is
for the data series line is to go from the value axis to the secondary
value axis, rather than starting from the first value in the data
series to the middle of the last value in the data series. Gap width
is grayed out. Is there some way of doing this? I can mail a sample to
anyone who wants to see an example of what I'm talking about.
I did a quick look in Google Groups but I didn't see anything that
looked like it applied. I appreciate any help you can give me. --Eva
Whitley

5.Finding Minimum Value in series, excluding zero values

I am trying to find the smallest value in a series, but exclude the
cells that have zero values.
For Example:
A B C D E F G
2 1.1 4 0 0 0 0
I want the return value to be 1.1 (the smallest in the row excluding
0)
Is this possible?

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

7. Excel Charts - Value Y axis scale - locking values to prevent changing

8. How to plot chart where X axis values START >1