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,
-markc
4.Changing value of chart axes based on the minimum value of the plotted series
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
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