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



  • 1. date/month problem
    i have to link my workbook thru the vba code. The logic is that i need to look for months. LIke if my worksheet is of may month then i need to link with a column of anohter workbook which is also may and likewise continue for forthcoming months. i search for may-04 in the workbook. My thought is what if the user changes May-04 to May'04 or any other format....! How to resolve this there a way whereby i put a condition??? or do i need to write a lot of if condition's????????? any thots will be appreciated
  • 2. For i = 01 to 20
    I frequently have to run loops which ideally should be like this: For i = 01 to 20 I need i to be 01 rather than 1 because that's what's the format required in a string. However, if I type like above, VBA automatically takes away the zero in 01. So I have to test if i is greater or smaller than 10, and add a zero back to i if it's < 0. Is there any way I can make VBA accept 01 as a valid number?
  • 3. Database Export to Excel
    We have a Database program here (SQL not Access) that exports reports to Excel. These reports contain odd combinations of numbers that mean something to the users of the database and to the programmers of it, but not to me. Anyway, I recently upgraded from Office 2000 on our terminal server (Win2K) to Office XP. Since then the num,bers in this worksheet are being truncated and the formats are changing. For instance, a number such as 2E152 appears as 2.00E+152 or something like 0100a will appear as 1:00 AM, we are also having the leading 0's for a number deleted. I know how I can change the format for each cell individually, but how can I change the formatting for cells in the entire spreadhseet to read the munbers as text only. Or some other fix would be great. I have Office XP on a nother server and this export isn't goofed like this. Don't understand it and have too much to do to spend more time on it so any help would be awesome! Thanks!
  • 4. Access picture data
    I have a SQL Table containing picture data among other things. I also have a need to access that picture data from within an Excel Worksheet which already contains the index values. Do you have any suggestions on how to access a required photo from the SQL table and paste it onto the worksheet based on the index value selected? -- Thank you in advance for your time. Regards, Ken
  • 5. form button question
    hi Is the Name of a form button the same as the Caption ON the button??? Unlike with command buttons from the control toolbox , I can't seem to see a Properties window for form buttons. Where is it? Thanks, bri

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

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


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


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.


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



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

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 

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

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 39 guest