Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plot value at top of chart
Is it possible to have the highest data point on a line graph plot at the
very top of a chart? For example, if the highest data point is 90 then I would like highest value of the y axis to also be 90 placing the data point at the top of the chart instead of excel automatically adding a "cushion (like 10) to the y axis. The data points vary each time the chart is created so i can't fix the value at 90. Thanks, Joe M. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plot value at top of chart
Hi Joe,
I was looking at this issue yesterday and came upon this macro. It set the high of the axis to the highest point of the data and also the low of the axis to the lowest point of the data. In case you want to start from 0, you will need to modified the code a bit. Hope this is what you want. Sub AutoScaleYAxes() Dim ValuesArray(), SeriesValues As Variant Dim Ctr As Integer, TotCtr As Integer With ActiveChart For Each X In .SeriesCollection SeriesValues = X.Values ReDim Preserve ValuesArray(1 To TotCtr + UBound(SeriesValues)) For Ctr = 1 To UBound(SeriesValues) ValuesArray(Ctr + TotCtr) = SeriesValues(Ctr) Next TotCtr = TotCtr + UBound(SeriesValues) Next .Axes(xlValue).MinimumScaleIsAuto = True .Axes(xlValue).MaximumScaleIsAuto = True .Axes(xlValue).MinimumScale = Application.Min(ValuesArray) .Axes(xlValue).MaximumScale = Application.Max(ValuesArray) End With End Sub "Joe M." wrote: Is it possible to have the highest data point on a line graph plot at the very top of a chart? For example, if the highest data point is 90 then I would like highest value of the y axis to also be 90 placing the data point at the top of the chart instead of excel automatically adding a "cushion (like 10) to the y axis. The data points vary each time the chart is created so i can't fix the value at 90. Thanks, Joe M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
plots sent to to a chart tab do not show plot & I loss the plot | Charts and Charting in Excel | |||
dot plot chart+chart wizard | Charts and Charting in Excel | |||
how to plot a polar chart / plot | Charts and Charting in Excel | |||
Excel chart : I want to plot on the same chart bar and line | Charts and Charting in Excel |